I would like to play a sound alert (standard wav file) when a particular condition is met in a spreadsheet cell. Specifically, I have live stock quotes coming into a spreadsheet through DDE and would like to play a sound alert when a particular value or condition is met. That trigger value or condition would be placed in another cell. I have programmed a few Excel macros, though am no expert on macros by any means, but I cannot find any command to play a sound. Could somebody please explain how I could do this?
Thanks and regards,