Method two: How to run a VBA sub procedure by clicking a button in Excel Another group on the Developer tab is the Controls group, which includes a button control.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.