|
How do you add sound file to a cell in excel
I want to add a sound file to any cell in excel so that when the data is
entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
You might use a worksheet_change event to hyperlink to a .wav file anywhere
on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
HI, How do you do it!
"Don Guillett" wrote: You might use a worksheet_change event to hyperlink to a .wav file anywhere on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
right click sheet tabview codeinsert thismodify to suitSAVE
Now if you ENTER something in that cell the .wav will play Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then ActiveWorkbook.FollowHyperlink Address:="c:\yourfolder\yourwavefile.wav" End If End Sub -- Don Guillett SalesAid Software "Martin" wrote in message ... HI, How do you do it! "Don Guillett" wrote: You might use a worksheet_change event to hyperlink to a .wav file anywhere on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
Hi Don, this work fine if I enter the data in this cell, so thanks for this,
but I want to add data into say cell $D$3 and using an if statement, if it is true and the text appears in the cell the ding sounds. like: if(D310,"too high","") so if the value in cell 3 is more than 10 then the sound is played otherwise it is silent "Don Guillett" wrote: right click sheet tabview codeinsert thismodify to suitSAVE Now if you ENTER something in that cell the .wav will play Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then ActiveWorkbook.FollowHyperlink Address:="c:\yourfolder\yourwavefile.wav" End If End Sub -- Don Guillett SalesAid Software "Martin" wrote in message ... HI, How do you do it! "Don Guillett" wrote: You might use a worksheet_change event to hyperlink to a .wav file anywhere on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
Hi Don
The value in $D$3 controls how the if statement in $A$1 responds, what I need is that when "too high" appears in cell $A$1 because the value is higher than the IF statement criteria the sound is activated "Don Guillett" wrote: IF I understand properly just change If Target.Address = "$A$1" Then to If Target.Address = "$A$1" and target10 Then Don Guillett SalesAid Software "Martin" wrote in message ... Hi Don, this work fine if I enter the data in this cell, so thanks for this, but I want to add data into say cell $D$3 and using an if statement, if it is true and the text appears in the cell the ding sounds. like: if(D310,"too high","") so if the value in cell 3 is more than 10 then the sound is played otherwise it is silent "Don Guillett" wrote: right click sheet tabview codeinsert thismodify to suitSAVE Now if you ENTER something in that cell the .wav will play Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then ActiveWorkbook.FollowHyperlink Address:="c:\yourfolder\yourwavefile.wav" End If End Sub -- Don Guillett SalesAid Software "Martin" wrote in message ... HI, How do you do it! "Don Guillett" wrote: You might use a worksheet_change event to hyperlink to a .wav file anywhere on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
How about a worksheet_calculate instead
Private Sub Worksheet_Calculate() If Range("a1") = "too high" Then MsgBox "Hi" End Sub -- Don Guillett SalesAid Software "Martin" wrote in message ... Hi Don The value in $D$3 controls how the if statement in $A$1 responds, what I need is that when "too high" appears in cell $A$1 because the value is higher than the IF statement criteria the sound is activated "Don Guillett" wrote: IF I understand properly just change If Target.Address = "$A$1" Then to If Target.Address = "$A$1" and target10 Then Don Guillett SalesAid Software "Martin" wrote in message ... Hi Don, this work fine if I enter the data in this cell, so thanks for this, but I want to add data into say cell $D$3 and using an if statement, if it is true and the text appears in the cell the ding sounds. like: if(D310,"too high","") so if the value in cell 3 is more than 10 then the sound is played otherwise it is silent "Don Guillett" wrote: right click sheet tabview codeinsert thismodify to suitSAVE Now if you ENTER something in that cell the .wav will play Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then ActiveWorkbook.FollowHyperlink Address:="c:\yourfolder\yourwavefile.wav" End If End Sub -- Don Guillett SalesAid Software "Martin" wrote in message ... HI, How do you do it! "Don Guillett" wrote: You might use a worksheet_change event to hyperlink to a .wav file anywhere on your computer. -- Don Guillett SalesAid Software "Martin" wrote in message ... I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
Hi Martin
I want to do the same thing but have not been successfull, have you found a solution? "Martin" wrote: I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
Didn't you just get an answer from Debra?
-- Vasant "George" wrote in message ... Hi Martin I want to do the same thing but have not been successfull, have you found a solution? "Martin" wrote: I want to add a sound file to any cell in excel so that when the data is entered into the cell by a user or when a calculation is performed by say an IF statement, that expression is TRUE then a sound is made. |
| All times are GMT +1. The time now is 08:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com