Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event Sub when one specific cell changes
Hi,
I am using Excel 2007. I have written a VBA Sub that I want to be called any time the value in one particular cell is changed. I know I can do this by creating a Worksheet_Change() Sub and checking the 'Target' Range parameter to see if the changed cell is the one I want to watch. The drawback of this is that this Sub gets called any time *any* cell is changed. In my case, this will get called alot because I have a value in another cell that changes once per second (it displays the current time). I was wondering if there is an event Sub other than Worksheet_Change() that would be called only when the one cell I want to watch changes? Thanks in advance, Paul Kraemer -- Paul Kraemer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run an event upon changing the value of a specific cell? | Excel Worksheet Functions | |||
Event when a specific cell changes | Excel Discussion (Misc queries) | |||
Change Event on a Specific Cell | Excel Worksheet Functions | |||
If event When a specific cell changes | Excel Programming | |||
Worksheet_Change Event triggered off specific cell | Excel Programming |