Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to execute a specific routine whenever a cell of a certain column
changes. All is OK if I press enter and the cursor is programmed to stay in the cell. Then I check the ActiveCell.Column property and execute the code. I have a problem if the user leaves the cell i.e. with a right or left arrow and the active column upon execution of the Worksheet Change routine is different to the one I wish to monitor. Is there a way to know the address of the cell that triggered the Change Event instead of the current/active cell ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet Change event | Excel Discussion (Misc queries) | |||
Using this Automatic Resizing Macro with Worksheet Change | Excel Discussion (Misc queries) | |||
Worksheet Change Event | Excel Discussion (Misc queries) | |||
change source worksheet | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) |