How to Monitor a change in a formula's result?
 

Is there a routine that can be used to monitor a formula
and open a msgbox when the formula's result changes?
Worksheet_Change,
Workbook_SheetChange, and
Workbook_SheetCalculate
will not do this, they only react to changes
in the actual contents of the cell, not
changes in what is displayed when a formula
updates.

I'm desperate, please help???!!!???

How to Monitor a change in a formula's result?
 

You would have to use the calculate event and store the previous result in a
variable, comparing against that to determine if there has been a change.

--
Regards,
Tom Ogilvy

Gary Desroches wrote in message
...
Is there a routine that can be used to monitor a formula
and open a msgbox when the formula's result changes?
Worksheet_Change,
Workbook_SheetChange, and
Workbook_SheetCalculate
will not do this, they only react to changes
in the actual contents of the cell, not
changes in what is displayed when a formula
updates.

I'm desperate, please help???!!!???