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.

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.

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.