Get name of clicked Shape

[Zurn]

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

How can I do this?

[Harald Staff]

Try

MsgBox Application.Caller

HTH. Best wishes Harald

"Zurn" <[email protected]> skrev i melding
news:[email protected]...
>
> I have several shapes created dynamically. Every shape has the same
> macro attached to it. By clicking a shape, I want to show a the same
> form with info of the shape eg. showing a label with the current shape
> clicked.
>
> How can I do this?
>
>
> --
> Zurn
> ------------------------------------------------------------------------
> Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
> View this thread: http://www.excelforum.com/showthread...hreadid=564283
>

[Zurn]

ok, thanks

[Bob Phillips]

Use Application.Caller

--
HTH

Bob Phillips

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

"Zurn" <[email protected]> wrote in message
news:[email protected]...
>
> I have several shapes created dynamically. Every shape has the same
> macro attached to it. By clicking a shape, I want to show a the same
> form with info of the shape eg. showing a label with the current shape
> clicked.
>
> How can I do this?
>
>
> --
> Zurn
> ------------------------------------------------------------------------
> Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
> View this thread: http://www.excelforum.com/showthread...hreadid=564283
>