Excel Macro for Msg Popup with OK and SNOOZE

Vote count:

0

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 changes 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, where as "Snooze" will again remind the same message in 2 minutes.

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

Can anybody help me with the macro for the same.

Regards

Vaibhav

asked 1 min ago

user3581113

1