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

Get FREE Advanced Excel Exercises with Solutions!

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.


Popup Reminder in Excel: 3 Ideal Examples

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

popup reminder in excel


1. Add Popup Reminder for Due Dates in Excel

In the first method, we will discuss the procedures to set due date reminder. 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, rightclick on the sheet name.
  • Secondly, from the Context Menu, select View code.

Add Popup Reminder for Due Dates in Excel

  • 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 a new name added in the reminder popup notification.

popup reminder in excel result


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.

Insert Popup Reminder Based on Cell Value

Please, follow the stepwise procedures given below.

  • Firstly, rightclick 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.

popup reminder in excel result

Read More: How to Create Notifications or Reminders in Excel


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.

Set Popup Reminder as Alarm in Excel

  • Then, press Alt + F11 to open the VBA window.
  • Further, from VBA Projects select the active sheet and rightclick.
  • 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.

popup reminder in excel result


Download Practice Workbook

You can download the practice workbook from here.


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.


Related Articles


<< Go Back to Alerts in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo