looping alarm message, running in the background

[claes, singapore]

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!

 

[Bob Phillips]

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)

 

[Robin Hammond]

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