| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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???!!!??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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???!!!??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round a formula's result | Excel Worksheet Functions | |||
| Cell displays formula instead of the formula's result | Excel Worksheet Functions | |||
| CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR | Excel Discussion (Misc queries) | |||
| Can I show a formula's result on a worksheet tab? | Excel Worksheet Functions | |||
| how do i copy a formula's result to another cell, without copying. | Excel Worksheet Functions | |||
![Gary Desroches[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
