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.