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

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

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38010