LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CC CC is offline
external usenet poster
 
Posts: 91
Default 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))


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I make an excel cell "mark" or "unmark" when clicked on? Rick Excel Discussion (Misc queries) 6 January 8th 06 10:15 PM
In excel, can you make a cell blink? giveya50 Excel Discussion (Misc queries) 7 May 13th 05 02:28 PM
How do I enter a wave sound file into an excel cell? dkimball Excel Discussion (Misc queries) 2 March 28th 05 08:35 PM
how do I make a cell in Excel required to be populated? Tia Excel Discussion (Misc queries) 1 February 10th 05 12:35 AM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"