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

justice wrote:
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


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(x0.0089,REPT("Sell! ",20))

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



Harlan Grove wrote:
justice wrote:
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


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(x0.0089,REPT("Sell! ",20))

Gentle people

I've try to use this code but nothing happen
what I did wrong ?
cc



"Harlan Grove" wrote:

justice wrote:
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


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(x0.0089,REPT("Sell! ",20))