Can sounds be played when cell value changes?
 

I was wondering if it is possible to play a wav file when the value of a cell
changes.
If so, how can I do this?
Any suggestions would help, thanks!

Can sounds be played when cell value changes?
 

"Ruben" wrote in message
...
I was wondering if it is possible to play a wav file when the value of a
cell
changes.
If so, how can I do this?
Any suggestions would help, thanks!

Hi Ruben

You can also coax Excel to issue a vocal warning when the target cell
changes


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Application.Speech.Speak "The cell contents have changed"
End If
End Sub



Regards N10