Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On Click Event | Excel Programming | |||
Help Using Click Event | Excel Programming | |||
Click event to run only once | Excel Programming | |||
Click event to run only once | Excel Programming | |||
On Click Event?, and how to use | Excel Programming |