Pop up Message with option of OK and SNOOZE

[mr_andreson]

I am trying to do a excel macro which can inform the user through pop up message once time reached at 1400 (2PM) & 1700 (5PM)

For example:

D1 =TEXT(NOW(),"HHMM") (This is Auto updating clock which I have put through another macro, this will be updating every second)

J2 = 1400
J3 = 1700

When the D1 clock value is equal to J2 (i.e. 1400) it should pop out message "Its 2 PM save your work" (this popup will come with 2 button of OK and Snooze, "OK" will finish the cycle of pop up, whereas "Snooze" will again remind the same message in 2 minutes.

Same will be done when D1 clock changes to J3 (i.e.1700)

[HaHoBe]

Hi, mr_andreson,

the normal Message Box does not have a buttoin called "snooze" so you would need to create a userform in VBA to do the job. Maybe have a look at Application.OnTime for starting the macro to show the UF at the given times (the next start should be given as wanted).What should happen if a different workbook is active at the given times?

Ciao,
Holger