If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sound / Audible Alert in a Woksheet ?
I am monitoring stocks.
I have a column of formulas that returns Yes or No. In almost all cases, the cell value is No. Once every few days, a value can switch to Yes. Is there a way that I can have the spreadsheet give me an audible alert if the value changes to Yes ? Thank you in advance. |
#2
|
|||
|
|||
Carl,
John Walkenbach has an example http://www.j-walk.com/ss/excel/tips/tip87.htm -- HTH Bob Phillips "carl" wrote in message ... I am monitoring stocks. I have a column of formulas that returns Yes or No. In almost all cases, the cell value is No. Once every few days, a value can switch to Yes. Is there a way that I can have the spreadsheet give me an audible alert if the value changes to Yes ? Thank you in advance. |
#3
|
|||
|
|||
thank you. i tried using the macro but ran into a problem. since my
spreadsheet is updating with dde links, the sound breaks up when the alarm is triggerred. Do you have any experience with this macro ? "carl" wrote: I am monitoring stocks. I have a column of formulas that returns Yes or No. In almost all cases, the cell value is No. Once every few days, a value can switch to Yes. Is there a way that I can have the spreadsheet give me an audible alert if the value changes to Yes ? Thank you in advance. |
#4
|
|||
|
|||
Not with DDE I am afraid!
-- HTH Bob Phillips "carl" wrote in message ... thank you. i tried using the macro but ran into a problem. since my spreadsheet is updating with dde links, the sound breaks up when the alarm is triggerred. Do you have any experience with this macro ? "carl" wrote: I am monitoring stocks. I have a column of formulas that returns Yes or No. In almost all cases, the cell value is No. Once every few days, a value can switch to Yes. Is there a way that I can have the spreadsheet give me an audible alert if the value changes to Yes ? Thank you in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New mail alert sound when Outlook is not the default mailreader? | Graham Mercer | General Discussion | 2 | June 18th, 2005 01:53 PM |
no sound alert for new email | CCPNAF | Installation & Setup | 1 | May 26th, 2005 08:41 PM |
Where is the sound that plays for alert - Outlook 2003? | ayz | General Discussion | 8 | July 15th, 2004 06:08 PM |
Sound Library Questions | Al Stearns | Powerpoint | 2 | May 25th, 2004 02:47 AM |
Excel sound alert | Michelle | Worksheet Functions | 1 | December 31st, 2003 02:58 PM |