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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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,215,220
Messages
6,123,695
Members
449,117
Latest member
Aaagu

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