How to make a cell trigger a Sound in Excel

J

justice

Is there a way to make excel play a sound on a > or < number?

I am using a futures program that can put the last trade number in a
cell such as 0.008900, I want to make excel play a sound when the cell
number reaches a number such as > than 0.008900

Thank you
 
H

Harlan Grove

justice said:
Is there a way to make excel play a sound on a > or < number?

I am using a futures program that can put the last trade number in a
cell such as 0.008900, I want to make excel play a sound when the cell
number reaches a number such as > than 0.008900
Click to expand...


Not possible without VBA. With VBA, you could try the following udf
which uses Excel's speech synthesis.

Function SayIt(c As Boolean, s As String)
If c Then Application.Speech.Speak s
SayIt = c
End Function

You can then use this in worksheet formulas like

=SayIt(x>0.0089,REPT("Sell! ",20))
 
J

justice

Harlan:
Thanks I found a way in the excel.mis group. I
had to make a VBA program and it works on a > or < number.
However I know nothing about the VBA. I was able to copy the file in and
substitute my own wav file, and it does work.


Here was the answer:

Hi Antonio

See
http://www.j-walk.com/ss/excel/tips/tip87.htm
where you can specify your own recordings to be played.

HTH. Best wishes Harald
 
Top