View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
claes, singapore claes, singapore is offline
external usenet poster
 
Posts: 1
Default 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!