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.

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 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.