Resolved >> Play a sound when a cell equals a certain value

[AussieExcelUser]

Is there any way of playing a sound (or even better, speech) whenever a specific cell equals a certain value or contains a certain string (such as "Alarm")?

This has to happen automatically as the cell updates and require no interaction.

Any suggestions would be appreciated.

[VBA Noob]

This link may help

http://j-walk.com/ss//excel/tips/tip87.htm

VBA Noob

[AussieExcelUser]

Excellent, thanks VBA Noob, I now have an audio alarm sounding exactly as I needed it.

Your assistance is much appreciated.

[VBA Noob]

Glad to hear....excuse the pun.

VBA Noob

[tangmere.milli]

Hey there,

I am trying to get this function to work, but when I use the formula =Alarm(A1,">=1000"), all I get in the Excel workbook is #Name?.

Am I missing something??!

Thanks in advance,

TM