Adding sound when input pops up

  • Thread starter Thread starter click4mrh
  • Start date Start date
C

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.
 
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
 
Back
Top