Adding sound when input pops up

[click4mrh]

Looking for a special tone, or beep to sound when hidden text that is
triggered by a result, pops up within the worksheet.

Example: If(a1>100,"budget exceeded","")

When the hidden "budget exceeded" appears, I want the worksheet to
"beep", or some such aubidle advisory.

Your help is appreciated.

 

[Frank Kabel]

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

 

[ste mac]

Hi,
you could maybe use this...

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target = Range("A1") Then
If Target.Value > 100 Then _
Call sndPlaySound32("c:\test\MySound.WAV", 0)
End If

End Sub

hth
seeya ste