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.

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.

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.

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.