Detect Form Button in VBA

[Rocky0201]

Hi,

I created several Form Buttons on a sheet in my Workbook.

My question is, when the Button is pressed and I enter the macro the Button points too, is there a way in my VB code to determine which Button was pressed i.e., "Button 1", "Button 2", etc?

Thanks,

 

[Jerry Sullivan]

Hi Rock0201,

You can use Application.Caller...

Sub MyMacro()
    MsgBox "MyMacro was called by: " & Application.Caller
End Sub

 

[Rocky0201]

Amazing!!!

Jerry, thank you very much. Works great!!!