assign excel 2003 macro with parms to shape

G

Guest

I have different shapes with one common macro. I would like to know which
shape name was used to envoke the macro. Any ideas would be greatly
appreciated.
 
H

Héctor Miguel

hi, Marvin !
I have different shapes with one common macro.
I would like to know which shape name was used to envoke the macro.
Any ideas would be greatly appreciated.
Click to expand...

depending on the figure type...
did you already attempt with Application.Caller ?

hth,
hector.
 
N

NickHK

Héctor,
I was going to suggest that, but initial tests from the routine showed:
? TypeName(Application.Caller)
Range
which was a bit confusing.

Now it works, showing:
? TypeName(Application.Caller), Application.Caller
String Rectangle 3

Can't repeat the error now, so who knows...

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to unassign macro from shape 4
Shape Arrays VBA 0
Finding name of shape that was last clicked - Application.Caller 5
Which Shape Ran The Macro? 5
Create shape, name shape, add text to shape 2
Programming "Shape" objects 14
macro associated with shape object, useful approach if can be solv 1
disable a shape 1

Top