passing variables from Shapes to VBA

M

Mike Movchan

What I'm trying to do:
I want to double click a shape and have it run some code specific to that
shapes Name or NameID. Right now I have it setup to run a macro on a double
click event through the shape sheet properties, this is good, but I dont
want to have a macro for each shape, so it would be helpful if I could pass
the NameID to the macro as a variable where I could then share the same Sub
for all shapes.

Regards,
Mike M
 
J

JuneTheSecond

One idea might be to run the macro through action section of the pagesheet.
When you right-click on the page, then a menu appear, and you can select a
manu
to run the macro.
 

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

Top