How to make a cell trigger a Sound in Excel
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 |
How to make a cell trigger a Sound in Excel
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)) |
How to make a cell trigger a Sound in Excel
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)) |
How to make a cell trigger a Sound in Excel
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)) |
All times are GMT +1. The time now is 09:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com