Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I would like to be able trigger an event procedure everytime a Shape is selected by the User . I know that there is no such native events for Worksheet Shapes but I was wondering if anyone could come up with a workaround WITHOUT using a Timer as this would make the Code much less performant. Regards. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Possibly use the onaction property of the shape to assign a macro to - this
will fire when the shape is clicked. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi all, I would like to be able trigger an event procedure everytime a Shape is selected by the User . I know that there is no such native events for Worksheet Shapes but I was wondering if anyone could come up with a workaround WITHOUT using a Timer as this would make the Code much less performant. Regards. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom,
What I meant was Selecting the Shape Not Clicking on It ...the same as when you want to move it or change its size . Regards. "Tom Ogilvy" wrote: Possibly use the onaction property of the shape to assign a macro to - this will fire when the shape is clicked. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi all, I would like to be able trigger an event procedure everytime a Shape is selected by the User . I know that there is no such native events for Worksheet Shapes but I was wondering if anyone could come up with a workaround WITHOUT using a Timer as this would make the Code much less performant. Regards. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I select a shape, I click it.
However, I doubt there is going to be a way for you to trap the selection of a shape. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Thanks Tom, What I meant was Selecting the Shape Not Clicking on It ...the same as when you want to move it or change its size . Regards. "Tom Ogilvy" wrote: Possibly use the onaction property of the shape to assign a macro to - this will fire when the shape is clicked. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi all, I would like to be able trigger an event procedure everytime a Shape is selected by the User . I know that there is no such native events for Worksheet Shapes but I was wondering if anyone could come up with a workaround WITHOUT using a Timer as this would make the Code much less performant. Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use selection change instead of double click event? | Excel Discussion (Misc queries) | |||
Selection Change Event | Excel Programming | |||
Selection Change Event | Excel Programming | |||
Selection Change Event... | Excel Programming | |||
Autofilter.Selection - After Change Event??? | Excel Programming |