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

  • Thread starter Thread starter Gary Desroches
  • Start date Start date
G

Gary Desroches

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???!!!???
 
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.
 
Back
Top