Quote Originally Posted by Paul_Hossler
Any time I change a cell on Sheet1 while the condition is true, it plays a sound.

Did you want it to play continously while the condition is true? (Sounds real annoying to me ), or maybe every 15 seconds while the condition is true?

Is it only those 2 cells you're comparing?

Like Mac said, you can use OnTime.
Paul
Hey, thanks Paul that is some substantial coding there

I do want it to play continuously, but in reality the value is changing rapidly in such a manner that I doubt it would beep more than 3 times consecutively.

Cell D9 is compared with the other B-cell, for the buy signal....but I think I can add that code in.

Thanks again fellas