How to Create Popup Reminder in Excel (3 Ideal Examples)

While we work on Excel, sometimes we want to get reminder of a task. Also, the reminder can be based on a dataset of Excel. Here, we will show the ways to create popup reminder in Excel with 3 ideal examples.

Table of Contents hide

Download Practice Workbook

3 Ideal Examples of Popup Reminder in Excel

1. Add Popup Reminder for Due Dates in Excel

2. Insert Popup Reminder Based on Cell Value

3. Set Popup Reminder as Alarm in Excel

Conclusion

Download Practice Workbook

You can download the practice workbook from here.

Popup Reminder.xlsm

3 Ideal Examples of Popup Reminder in Excel

In this section, we will demonstrate the method to create popup reminder in Excel with 3 ideal examples. For demonstrating the procedures, we have included a dataset having Buyer, Amount and Due Date for the invoice of some customers.

1. Add Popup Reminder for Due Dates in Excel

In the first method, we will discuss the procedures to create reminders for due dates. For that, we will use Visual Basics for Applications (VBA) code that will give the name of the Buyer from the dataset if their Due Date is past our current date. Let’s jump to the stepwise procedures.

Firstly, select the active sheet from the Sheet Tab at the bottom of the worksheet. Also, right–click on the sheet name.
Secondly, from the Context Menu, select View code.

Afterward, a code window will appear.
Write the following code in the code window.

Option Explicit
Sub DueDat()
Dim DueDatCol As Range
Dim DueD As Range
Dim PopUpNot As String
Set DueDatCol = Range("D5:D9")
For Each DueD In DueDatCol
If DueD <> "" And Date >= DueD - Range("D11") Then
PopUpNot = PopUpNot & " " & DueD.Offset(0, -2)
End If
Next DueD
If PopUpNot = "" Then
MsgBox "No buyer to chase today."
Else: MsgBox "Chase these buyers today: " & PopUpNot
End If
End Sub

Note: In the code part: (If Due <> “” And Date >= Due – Range(“D11”) Then), as we didn’t include any value in Cell D11. So, our due dates will be counted if the date in the dataset is the current date or any future date. If we included any numeric value in Cell D11 the due dates will be before those days (included numeric value) of the current date.

Then, press the Run button from the VBA window.

Finally, running the code will take us to the worksheet and show the reminder with the names of the buyers with due dates.

Further, we can change the due date of any buyer.
Again, run the code and we will see new name added in the reminder popup notification.

2. Insert Popup Reminder Based on Cell Value

Now, we want to show you the procedures to get a popup reminder when we select a cell with a specific numeric value. We used the same dataset containing Buyer, Amount and Due Date.

Please, follow the stepwise procedures given below.

Firstly, right–click on the sheet name from the Sheet Tab at the bottom.
Secondly, choose View code from the context menu.

Consecutively, a code window will appear.
Write the following code in that window.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim xCl As Range, Rng As Range
    On Error Resume Next
    Set Rng = Application.Intersect(Target, Range("C5:C9"))
    If Not Rng Is Nothing Then
        For Each xCl In Rng
            If xCl.Value = "50000" Then
                MsgBox "You selected cell " & xCl.Address, vbInformation, "Reminder in Excel"
                Exit Sub
            End If
        Next
    End If
End Sub
Private Sub Worksheet_selectionChange(ByVal Target As Range)
    Dim xCl As Range, Rng As Range
    On Error Resume Next
    Set Rng = Application.Intersect(Target, Range("C5:C9"))
    If Not Rng Is Nothing Then
        For Each xCl In Rng
            If xCl.Value = "50000" Then
                MsgBox "You selected cell " & xCl.Address, vbInformation, "Reminder in Excel"
                Exit Sub
            End If
        Next
    End If
End Sub

Note: In the code part, ( If xCl.Value = “50000” Then) you can set a different number instead of 50000 and that will enable the popup reminder when we select a cell having that new number.

Afterward, come back to the worksheet and select random cells.
Finally, we will see a popup reminder when we select a cell having a value of 50000.

3. Set Popup Reminder as Alarm in Excel

We can also set a popup reminder as an alarm in Excel. We will use the VBA code to set the popup reminder as an alarm. Let’s follow the stepwise procedures given below.

Firstly, open the worksheet where you want the popup reminder as alarm.

Then, press Alt + F11 to open the VBA window.
Further, from VBA Projects select the active sheet and right–click.
Afterward, select Insert > Module.

Consecutively, a code window will appear. Write the following code there.

Dim Alrm As Double
Dim Mesage As String
Sub PopupAlarmReminder()
Dim Whn As String
If Alrm = 0 Then
Whn = InputBox("What time would you like the reminder message to Popup?")
If Whn <> "" And Whn <> "False" Then
Mesage = InputBox("Please enter the reminder message")
On Error Resume Next
Alrm = Date + TimeValue(Whn)
On Error GoTo 0
Application.OnTime Alrm, " PopupReminder "
End If
Else
Beep
Application.Speech.Speak Mesage
MsgBox Mesage
Mesage = ""
Alrm = 0
End If
End Sub

Afterward, press the Run button from the VBA window.

Simultaneously, we will get a Microsoft Excel window asking for reminder time.
Set a time for the popup reminder as an alarm and press OK.

As a result, a second window will appear.
Write the reminder message you wish.
Also, press OK.

Finally, wait for the alarm time.
An alarm with a popup reminder will appear at the time we have set it.

Conclusion

Popup reminder is quite useful while working in Excel. Here, we have shown the procedures to create popup reminder in Excel with 3 ideal examples. If you have any queries or suggestions, please leave a comment. Visit our ExcelDemy Website for similar articles regarding Excel.