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.
Download Practice Workbook
You can download the practice workbook from here.
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
- 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
- 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.
Read More: How to Create Notifications or Reminders in Excel (5 Methods)
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.
Read More: How to Disable Alerts in Excel VBA (With Easy Steps)
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.