How To Determine which CommandBar button started a macro using VBA?

In this article, you will learn how to determine which CommandBar button started a macro using VBA ** in Microsoft Excel. Let’s see them below!! Get the official version of **MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Example

• Firstly, in the Excel Worksheet, you have to go to the Developer Tab.
• Then, you need to ** ** select the Visual Basic option under the Code section.

Select Visual Basic

• Now, you have to copy and paste the code given below.

Sub DummyMacro()
    If Application.CommandBars.ActionControl Is Nothing Then 
    ' the macro was not started from a commandbar button
        MsgBox "This could be your macro running!", vbInformation, _
            "This macro was not started from a CommandBar button"
    Else ' the macro was started from a commandbar button
        MsgBox "This could be your macro running!", vbInformation, _
            "This macro was started from this CommandBar button: " & _ 
            Application.CommandBars.ActionControl.Caption
    End If
End Sub

• You need to save the code by selecting it and then close the window.

Save the Code

• Again, you have to go to the Excel Spreadsheet , and click on the Developer Tab.
• Then, you need to choose the Macros option in the Code section.

Choose Macro option

• Now, you have to make sure that your macro name is selected and click the *Run * button.

Run the Code

• Finally, after running the macro, you will get the *output * as given below in Excel.

Output

Wrap-Up

We hope that this article gives you guidelines on how to determine which CommandBar button started a macro using VBA in Microsoft Excel. ** ** Please leave a comment in case of any queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Related Articles:

• Excel Formulas to Find Pass or Fail Using COUNTIF Function!!
• Insert Multiple Option Buttons at Once in Excel Office 365!!
• Batch Delete Option Buttons with One Click in Excel Office 365!!
• How to use DATE Function in Microsoft Excel 365?