#1   Report Post  
Posted to microsoft.public.excel.programming
tjh tjh is offline
external usenet poster
 
Posts: 96
Default click event

Hello,

I would like to run a procedure whenever a cell is clicked/selected on a
spreadsheet. The standard event procedures do not seem to have one of these.
I would also like this procedure to run, even if another procedure is
currently running --- therefore stopping the first procedure and then running
the click event procedure.

Thank you for your help.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,090
Default click event

Use the WorkSheet_SelectionChange event. Note that this procedure fires
only if a selection change is made. In other words, merely clicking on the
active cell will not do it. HTH Otto
"tjh" wrote in message
...
Hello,

I would like to run a procedure whenever a cell is clicked/selected on a
spreadsheet. The standard event procedures do not seem to have one of
these.
I would also like this procedure to run, even if another procedure is
currently running --- therefore stopping the first procedure and then
running
the click event procedure.

Thank you for your help.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default click event

SelectionChange event is basically what you describe although it is fired
whether the cell is entered via the mouse or keyboard. Unless you read
mouse movements in your running code, I don't believe the preemptive part is
a consideration.

--
Regards,
Tom Ogilvy


"tjh" wrote in message
...
Hello,

I would like to run a procedure whenever a cell is clicked/selected on a
spreadsheet. The standard event procedures do not seem to have one of

these.
I would also like this procedure to run, even if another procedure is
currently running --- therefore stopping the first procedure and then

running
the click event procedure.

Thank you for your help.



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
On Click Event Craig Excel Programming 3 December 2nd 05 07:26 PM
Help Using Click Event dnj Excel Programming 0 November 11th 04 08:21 PM
Click event to run only once gavmer[_93_] Excel Programming 0 October 12th 04 12:34 AM
Click event to run only once gavmer[_83_] Excel Programming 0 October 1st 04 01:24 AM
On Click Event?, and how to use Wandering Mage Excel Programming 5 June 7th 04 04:28 PM


All times are GMT +1. The time now is 03:38 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"