Get name of clicked Shape

[Zurn]

I have several shapes created dynamically. Every shape has the sam
macro attached to it. By clicking a shape, I want to show a the sam
form with info of the shape eg. showing a label with the current shap
clicked.

How can I do this

 

[Harald Staff]

Try

MsgBox Application.Caller

HTH. Best wishes Harald

 

[Zurn]

ok, thank

 

[Bob Phillips]

Use Application.Caller

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)