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

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