Starting macros when cell changes to TRUE

[Guest]

Hi you guys all out there

I have a very special problem with an excel sheet:

I got some live data which comes per DDE
so the sheet always changes
Now i got some IF-Conditions in EVERY line
if the condition TURNS true, i want to be notified (e.g. by a sound)

I guess I'll have to use "SheetCalculate"
and I already have a macro (based on sheetcalculate) which will beep, if ANY
condition IS true.
so it will almost beep always, as most likely at least ONE contition WILL be
true. but I ONLY want to hear the beep, when the condition JUST turned TRUE

Will be thankfull to any suggestions

Thank you in advance

THW

 

[bhofsetz]

Have you looked at using a Worksheet_SelectionChange event procedure?

It's not clear if your open sheet is actively updating or if your shee
updates every time it is opened

 

[Guest]

hi bhofsetz,

my sheet is updated per DDE, so there may be 20changes per second, or only
one...

the problem are not the changes by themselfes
the problem is to be notified in the moment when a specific cells value
TURNS to true

I don't need to be notified if the content IS already true because it would
ALWAYS notify me, as long as the value is true.
ONLY the time it changes from false to true is importatn

greetings
THW