VBA Code to Identify Selected Shape

[MinionKi]

You can assign a macro to pretty much any object in excel. My question is if when selecting an object that has a macro attached to it if you can have the Macro first identify which shape you have clicked.

For example if I were to click on "Object1" and the code that runs when I select "Object1" says if this is "Object1" then do "..." Else do "..."

Let me know if this isn't clear enough.

Thanks.

 

[StephenCrump]

Have a look at the Application.Caller Property.

 

[yky]

Check out the following link:

https://www.thespreadsheetguru.com/the-code-vault/2014/10/22/activeshape-with-vba

 

[MinionKi]

Application.Caller is exactly what I was looking for. Thank you. I ended up finding this property while running through someone else's code and it worked like a charm.

 

[OriginalAccess]

Before offering advice on this forum, please learn Excel and VBA. "Application.Caller" does not apply to ActiveX controls (buttons).
I truly wish the dilettanti would leave the field to the professionals.

At this point neither I, nor as far as I know, anyone else had figured a way to get the name of an ActiveX button without cycling (which involves KNOWING its name in advance.

I need to her the trailing number of "tbnLong56", when I do not know which "tbnLong**" was pressed

Good luck in your excel endeveaours