How To Add A Form Control Button To Run Your VBA Code

If you have a workbook that uses some VBA code and you want an easy way for someone to run the code (i.e. without them having the Developer tab enabled) then a form control button is a good option. The good thing about form control buttons is they can be made very prominent and labelled accordingly like “Click Here To Run” so a user will know what to do.

Add your button to a sheet.

Go to the Developer tab in the ribbon. If you don’t see this tab, read How To Enable The Developer Tab.
Press the Insert button found in the Controls section.
Select the Button Form Control from the menu.
Right click and hold the mouse then drag and release to create your button.
The Assign Macro window will pop up and you can select the VBA procedure you want to run from the button.
Press the OK button.

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.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.