View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Desroches[_2_] Gary Desroches[_2_] is offline
external usenet poster
 
Posts: 2
Default 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???!!!???