Sound / Audible Alert in a Woksheet ?

Carl,

John Walkenbach has an example

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
HTH

Bob Phillips

"carl" <carl@discussions.microsoft.com> wrote in message
news:C59A8E37-FD88-4644-AF72-D4BA3666692E@microsoft.com...
> 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" <carl@discussions.microsoft.com> wrote in message
news:1EF509D9-EBE1-45C5-B89B-25D80557D57A@microsoft.com...
> 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.
> >

Carl,

John Walkenbach has an example

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
HTH

Bob Phillips

"carl" <carl@discussions.microsoft.com> wrote in message
news:C59A8E37-FD88-4644-AF72-D4BA3666692E@microsoft.com...
> 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" <carl@discussions.microsoft.com> wrote in message
news:1EF509D9-EBE1-45C5-B89B-25D80557D57A@microsoft.com...
> 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.
> >

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" <carl@discussions.microsoft.com> wrote in message
news:C59A8E37-FD88-4644-AF72-D4BA3666692E@microsoft.com...
> 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" <carl@discussions.microsoft.com> wrote in message
news:1EF509D9-EBE1-45C5-B89B-25D80557D57A@microsoft.com...
> 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.
> >