assign excel 2003 macro with parms to shape

's Computer Specifications

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.

's Computer Specifications

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.

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

hth,
hector.

's Computer Specifications

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

"Héctor Miguel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> depending on the figure type...
> did you already attempt with Application.Caller ?
>
> hth,
> hector.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I use VBA to assign Macro to Shape within a Group of Shapes?	MikeZz	Microsoft Excel Programming	1	28th Jan 2009 01:25 AM
how do you assign a macro to a command button in Excel 2003	=?Utf-8?B?bnM=?=	Microsoft Excel Misc	5	25th Oct 2007 08:58 PM
How to assign a macro to a shape in a word document?	=?Utf-8?B?RnJhbms=?=	Microsoft Word Document Management	1	25th Feb 2005 01:45 AM
How to assign a macro to a button in Excel 2003?	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Programming	2	18th Feb 2005 04:51 PM
Assign macro to button in EXCEL 2003	Steffen Kuenstner	Microsoft Excel Programming	1	8th Jan 2004 11:04 AM