Add your button to a sheet.
To re-label the button to something more meaningful than button1, left click on the button and select Edit Text from the menu. You can also re-assign you button from this menu by selecting Assign Macro.
How To Add A Form Control Button To Run Your Vba Code
