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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

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