Adding sound clips into Excel

[Guest]

I would like to have a sound play when a cell that is receiving real-time
information (financial quotes) reaches a certain value. I envision it
working like a conditional format except that it would play a note instead of
turning the cell a color. The ability to have several different sounds for
different conditions would be ideal. Excel 2002.

 

[ilyaskazi]

Check this:

To Play sound files:
http://www.exceltip.com/st/Playing_sound_notes_using_VBA_in_Microsoft_Excel/461.html

To Play wav files:
http://www.exceltip.com/st/Playing_WAV-files_using_VBA_in_Microsoft_Excel/460.html

 

[Guest]

Hi, Ilyaskazi,

Have you ever been able to get the sound notes code to work?

I can't figure out how to invoke the PlaySoundNotesInExcel97 macro from
within my selection_change macro. I think it needs a parameter, but I don't
know what it is...

Thanks

Pete