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 - 30