How do I set a pop-up reminder in Excel at a specific time?

Use Application.OnTime in the Workbook_Open event: Application.OnTime TimeValue('15:00:00'), 'MacroName'. The macro named 'MacroName' runs at 3pm if the workbook is open.

Does the Excel pop-up reminder work when Excel is minimised?

Yes - Application.OnTime fires regardless of whether Excel is the active window, as long as the workbook is open and Excel is running.

How do I set a recurring daily reminder in Excel VBA?

At the end of the PopupRemind macro, call Application.OnTime TimeValue('15:00:00'), 'PopupRemind' again to re-schedule it for the same time tomorrow.

Excel Pop-Up Reminder at Specific Time

This is a useful code for creating a reminder that you want to pop up at a specific time in Excel. This reminder will show as long as the Excel workbook is open, even if it is not the active window at...

Let's say you want a message box to pop up at 3pm on a daily basis, reminding you to send out a report.

Place the following code in the ThisWorkbook sheet code area (access this from Developer >> VBA Editor) of your workbook:

Private Sub Workbook_Open()
Application.OnTime TimeValue (15:00:00"), "PopupRemind"
End Sub

Then Insert a new module, and place the following code (the text in the Msgbox can be customized as you wish):

Sub PopupRemind()
If MsgBox("It's time to work! Send the report out to Team Manager?", _
vbOKCancel + vbQuestion, "Reminder") = vbOK Then

MsgBox "Sending report..."

Else

MsgBox "Reminder dismissed."

End If
End Sub

Create a Timed Pop-Up Reminder in Excel That Fires at a Set Time

Frequently Asked Questions