looping alarm message, running in the background
 

Greetings,

Would anyone be able to advise on how to achieve a looping alarm, that keeps
on looping until the user acknowledge by pressing OK in a message box, or
something like that...

N.B. it's very important for me that the main macro can continue to run as
per normal (using OnTime to refresh stock prices every 5 minutes).

The whole purpose is to trigger an alarm if one of the stock prices reach a
certain price level at a certain time of the day.

Thanks!

looping alarm message, running in the background
 

Include a Do Loop that doesn't exit until you get a satisfactory response.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"claes, singapore" <claes, wrote in
message ...
Greetings,

Would anyone be able to advise on how to achieve a looping alarm, that
keeps
on looping until the user acknowledge by pressing OK in a message box, or
something like that...

N.B. it's very important for me that the main macro can continue to run as
per normal (using OnTime to refresh stock prices every 5 minutes).

The whole purpose is to trigger an alarm if one of the stock prices reach
a
certain price level at a certain time of the day.

Thanks!

looping alarm message, running in the background
 

If in XL2000 or higher, you can just show a modeless form with the alarm
message on it and the remainder of your code should continue to run.

If you have a large label on the form, and you get multiple alarms, you
could just keep updating the label with the new alarms when they occur.

Robin Hammond
www.enhanceddatasystems.com

"claes, singapore" <claes, wrote in
message ...
Greetings,

Would anyone be able to advise on how to achieve a looping alarm, that
keeps
on looping until the user acknowledge by pressing OK in a message box, or
something like that...

N.B. it's very important for me that the main macro can continue to run as
per normal (using OnTime to refresh stock prices every 5 minutes).

The whole purpose is to trigger an alarm if one of the stock prices reach
a
certain price level at a certain time of the day.

Thanks!