Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If a cell contains a certfain value, Beep
I want to be alerted if a certain value would ever be the value of a cell.
For example, if I have a balance sheet and the total Assets do not equal the total liabilities, I want to be notified. But I don't want to have to run a vb macro to be alerted. I thought I could just get a notification when the recalc is done that something is wrong. How do I set this up? I don't want to add a Watch to a cell, because you get no visual or audio that there is a problem. It just shows up in the watch box. I want to be beeped the instant an out-of-balance condition is created. Thanks for any help you can give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add sound ( beep ) if cell content changes in live data | Excel Discussion (Misc queries) | |||
BEEP | Excel Discussion (Misc queries) | |||
No Beep | Excel Programming | |||
Is BEEP all there is?? | Excel Programming | |||
I want to *beep* *beep*!!!! | Excel Programming |