Gary's Student
Beautiful ! It works.Thanks a lot.So simple and short.
Maybe you can expand a little more , telling me how to make the speech
repeat itself either a few times and/or continuously until I stop it by
hitting any key.

Also how can I change the value that activates the macro(the 100) to any
other number without having to edit the macro.If I could place this new
number(the substitute for the number 100) in cell C1 for example, it would be
easier.
How can I put a second macro for a different cell to be monitored?In the
same code?
Soli
"SOLI" wrote:

MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK.
HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN
THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE?
I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE
MACROS.TKS.