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

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???!!!???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Embed the same Excel multiple times 0
Formula appearing as Value in Formula Bar 1
Help writing formula for investing spreadsheet 0
Formula Response immediately? 0
Break points will be ignored in Excel 1
Access 2002 change report header text 0

Top