popup alarm message

[Southernw2002]

I would like to have a list of alarm times that reseult in a individual message popup. Basicallt two columns ,,, one with the time and the other with the corresponding message.....maybe 10 seperate times.
The popup would stay until the box is clicked .

I have been playing around with variuos VBA's but no real success .. any suggestions ?

[TMS]

You'd probably need to use the Change, Selection_Change, or Calculate events to initiate your subroutine. Your sub would need to loop through the times and check them ... of course, you are unlikely to catch the exact time so you'll need to check between one event time and the next. In other words, a time range rather than a specific time.

Regards, TMS

[Southernw2002]

Currently I have the following which does the firdt part ... but i would like the B column to match for the message that matches the time in column A..There are likely to be 10 rows of times.


Some help would (as always) be appreciated

Please Login or Register  to view this content.