Hello, I am running Excel 2003, and have very little programming experience,

I am a trader and have set up a simple spreadsheet that is fed real-time market data.

My eyes get sore because I currently have the sheet coded to flash "Buy" or "sell" every time the condition is met and I have to constantly monitor this and numerous other things...I'd like it to play a sound....

Here's the details:

I have the "real-time" data flowing into and updating cell X every second, and then a constant value in cell Y that I input before the market opens. I want an alarm of some kind to go off EVERY time X is less than Y....even if it happens 5 times per minute.

I tried the code in this thread, and a few other threads I found running a search, and its not working at all.

Any help would be appreciated

If you want to see my sheet and an explanation of how it works, I would be glad to send you my proprietary work...yes my eyes are that tired and in need of audio alert.