Thread: Adding Sound to Program
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Carlton Patterson Carlton Patterson is offline
external usenet poster
  
Posts: 95
Default Adding Sound to Program
Hi Bob,

I tried to add sound to the following excel program however I keep on
getting an error message saying "Sub or Function not defined". Can you
help?

Private Sub Worksheet_Calculate()
Static prevValue
If Range("I1").Value prevValue Then
PlayWavFile "C:\Windows\Media\Windows XP Print complete"
prevValue = Range("I1").Value
End If
End Sub

Cheers

Carlton



*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote