Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
detect cell change
hello, how can i fire an event if cell a1 is updated via a link? the worksheet_change event only works after manual entry in cell a1. ok thanks frank -- diepenbos ------------------------------------------------------------------------ diepenbos's Profile: http://www.excelforum.com/member.php...o&userid=21124 View this thread: http://www.excelforum.com/showthread...hreadid=396643 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
detect cell change
How about if you set up a Worksheet Change Event that would trap changes to
any cell in the worksheet rather than just the cell you are interested in. Each time the macro is tripped it would compare the value in the special cell to the value at the previous entry. (you would need to declare some kind of static variable to retain the memory) Since this is of general interest, please re-post if you can get something like it to work. Good Luck -- Gary's Student "diepenbos" wrote: hello, how can i fire an event if cell a1 is updated via a link? the worksheet_change event only works after manual entry in cell a1. ok thanks frank -- diepenbos ------------------------------------------------------------------------ diepenbos's Profile: http://www.excelforum.com/member.php...o&userid=21124 View this thread: http://www.excelforum.com/showthread...hreadid=396643 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill: can it detect change in value? | Excel Discussion (Misc queries) | |||
VB ; How do I detect a Comment in a cell | Excel Discussion (Misc queries) | |||
How to detect characters in cell? | Excel Discussion (Misc queries) | |||
Detect Value change of a Cell | Excel Programming | |||
How to detect if a cell is formula | Excel Programming |