Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default Shape Selection Event !!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Shape Selection Event !!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default Shape Selection Event !!

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Shape Selection Event !!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use selection change instead of double click event? ghost Excel Discussion (Misc queries) 1 December 26th 08 04:58 AM
Selection Change Event Jim Thomlinson[_3_] Excel Programming 0 April 28th 05 05:36 PM
Selection Change Event Jim Thomlinson[_3_] Excel Programming 3 April 28th 05 10:01 AM
Selection Change Event... Juan Sanchez Excel Programming 1 May 28th 04 10:16 PM
Autofilter.Selection - After Change Event??? Paul M.[_2_] Excel Programming 0 August 15th 03 05:16 AM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"