Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to alert me when the value of a formula in another sheet changes
Hi,
I'm working on a complex spreadsheet with many sheets and need to know if something I do in any sheet causes a particular cell value in the first sheet to change. I've played around with onevent macros but they seem to be triggered only if a cell changes content rather than changing value. ie. a cell is deleted or overkeyed, rather than a formula just giving a different value. Can anyone assist with the code I need to do this? Many thanks and Merry Christmas to all. Kind regards, Ana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can a work sheet have an alert to calendar | Excel Discussion (Misc queries) | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finished | Excel Programming | |||
How to delete a sheet without Alert message | Excel Programming |