If you don't mind, could you write me a small example? I understand your
idea...but I'm having trouble creating it. (I'm 4 months old in VBA).


"Tom Ogilvy" wrote:

The calculate event. You would have to use a static variable to record the
value of the cell each time, then compare it to the current value, take
action if appropriate, store the current value over the old value.

--
Regards,
Tom Ogilvy


"dumb and frustrated" wrote:

Is there a way to kick off a macro if the value of a specific cell changes?
The tricky part is that this particular cell's is driven by a formula (in
other words, the user does not manually enter data in this cell).