Forgive me for the double post, but is there a way to get an audio file, such as a .wav, to trigger in a cell when the value of that single cell changes?
Thanks,
~Sly
Forgive me for the double post, but is there a way to get an audio file, such as a .wav, to trigger in a cell when the value of that single cell changes?
Thanks,
~Sly
At least from Excel 2000, sound notes were removed from the application meaning you can't play specific sound files attached to cells. You can play a simple tone (the frequency and duration of the tone depend on your hardware and system software, and vary among computers) with a macro assigned to the worksheet you want the tone to play from when a specific cell value changes:
Private Sub Worksheet_Change(ByVal Target As Range)
'***NOTE: Change the cell reference below to your own ***
Target = ActiveSheet.Range("E23")
Beep ' Add more Beep statements below if you want multiples
End Sub
Hope this helps,
theDude
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks