Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mouse selection of shapes
Hi all,
I would like to run some vba code when the user selects a shape or an image. the procedure selectionchange() seem not to be useful with shapes but only with cells... can you please help me? thanks marco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mouse selection of shapes
Depending on the shape, you may be able to just assign a macro to it. Then when
the user clicks on the shape, the assigned macro will run. Try rightclicking on your shape and see if there's an "assign macro" option. If there isn't, you may want to share more info--the shape you used especially. perf wrote: Hi all, I would like to run some vba code when the user selects a shape or an image. the procedure selectionchange() seem not to be useful with shapes but only with cells... can you please help me? thanks marco -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mouse selection of shapes
first of all, thanks to all!
the fact is that i have created and addin capable of drawing blocks made by grouped standard blocks (and block as a box and a text box, or block etc etc)... the user can create these blocks with a toolbar made by me, and I would like to assign a macro when the user click on some of this shapes in order to disable the canc button (on some kind of blocks) I hope you understood my point. add manually a macro is not good for me, this should be assigne automatically by macro... thanks for every advice marco "Dave Peterson" wrote: Depending on the shape, you may be able to just assign a macro to it. Then when the user clicks on the shape, the assigned macro will run. Try rightclicking on your shape and see if there's an "assign macro" option. If there isn't, you may want to share more info--the shape you used especially. perf wrote: Hi all, I would like to run some vba code when the user selects a shape or an image. the procedure selectionchange() seem not to be useful with shapes but only with cells... can you please help me? thanks marco -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving shapes with the mouse | Excel Programming | |||
Moving Shapes with the mouse | New Users to Excel | |||
Bug, multiple selection of shapes | Excel Programming | |||
Programmatically add shapes to a selection | Excel Programming | |||
Disable selection of shapes | Excel Programming |