Excel VBA: How to Determine Name of Selected Active X Command Button as String

MacroEcon1337

Board Regular
Joined
Mar 16, 2017
Messages
65
Goal: I'd like to click a command button, located on a user form, and have a message box appear with the name of the command button object (that was just clicked).

Note 1: this is intended for Active X Buttons, not form buttons.

Note 2: The command button is located in a UserForm

Note 3: None of the below worked...

Dim ButtonName as String
ButtonName = ActiveForm.Shapes(Application.Caller).Name
MsgBox ButtonName

Dim ButtonName as String
ButtonName = Application.Caller
MsgBox ButtonName

Dim ButtonName As String
ButtonName = Application.Caller
MsgBox ButtonName

Dim ButtonName As String
ButtonName = Application.Caller.Name
MsgBox ButtonName

Any thoughts or suggestions are appreciated!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Update:

The code below returns "Frame1" in the message box prompt.
Dim ButtonName As String
ButtonName = Me.ActiveControl.Name
MsgBox ButtonName

 
Upvote 0
Nailed the solution:

ButtonName = Me.ActiveControl.Name
MsgBox ButtonName

My thanks to any who considered the problem.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top