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.

A command button is a control button; users can create a command button to set action by using codes in the VBA Editor. In this tutorial, we have explained how to use the command button in Excel.

When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run.