Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi group I am using the Office 2000 package
I am looking ofr a way to run a macro on the exit of a cell. Example I want to run the code each time the target leaves A1 I know you can run a macro each time there is a change of cell address that is not equal to A1 by using "Worksheet_SelectionChange" If Target.Address < A1 Then Bla Bla Bla But I would prefer to not run this entire code each time the cell target changes. Just when it leaves A1 One idea I had was to have part of a code run each time the address was equal to A1 then just hold until the address was not equal to A1 and then run. I am not sure how to do this though. Make sense? Other ideas? Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run macro on exit | Excel Discussion (Misc queries) | |||
Macro on exit cell | Excel Discussion (Misc queries) | |||
How do I exit a macro subroutine? | Excel Worksheet Functions | |||
Exit via macro only? | Excel Discussion (Misc queries) | |||
on exit macro | Excel Discussion (Misc queries) |