Is there a way to have an audio file such as a .wav trigger in a cell when the value for that single cell changes?
Thanks
~Sly
Is there a way to have an audio file such as a .wav trigger in a cell when the value for that single cell changes?
Thanks
~Sly
Look at this website http://www.j-walk.com/ss/excel/tips/tip59.htm
You'll also need to use Worksheet Events
Example:
Private Sub Worksheet_Change(ByVal Target As Range)
IF Target.Address(False,False) = "A1" then PlayWAV
End Sub
(Assuming the PlayWAV subroutine is included as per J-Walk example)
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks