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](http://cdn-5a6cb102f911c811e474f1cd.closte.com/wp-content/uploads/2017/01/Step-001-How-To-Add-A-Form-Control-Button-To-Run-Your-VBA-Code.png)
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.