- Download Workbook
- 5 Simple Methods to Create Notifications or Reminders in Excel
- Practice Section
- Conclusion
- 1. Utilize Excel Conditional Formatting to Make Notification or Reminders
- 2. Combine IF and TODAY Functions To Generate Notifications
- 3. Merge IF, TODAY, and AND Functions to Create Reminders in Excel
- 4. Apply Excel VBA Macros to Get Pop-Up Notification or Reminders
- 5. Add New Ribbon and Insert VBA to Obtain Notifications in Excel
If you want to create notifications or reminders in Excel, you have come to the right place. Here, we will walk you through 5 easy methods to do the task smoothly.
Download Workbook
You can download the following Excel file and practice while reading this article.
Create Notifications or Reminders.xlsm
5 Simple Methods to Create Notifications or Reminders in Excel
In the following dataset, you can see the Product and Supply Date columns. Here, we have several Supply Dates that include dates that are ahead of the present-day, and past-day dates. Further, using this dataset, we will go through 5 easy methods to create notifications or reminders in Excel.
Here, we use Excel 365. You can use any available Excel version.
1. Utilize Excel Conditional Formatting to Make Notification or Reminders
In this method, we will use the Conditional Formatting feature to create notifications or reminders in Excel. Using this method, we will mark the dates that are up to 30 days from today’s date.
Steps:
- First of all, select cells C5:C9.
- Here, you must select cells that you want to apply Conditional Formatting.
- After that, go to the Home tab >> select Conditional Formatting.
- This will bring out several Conditional Formatting options.
- Then, we will select New Rule.
- At this point, a New Formatting Rule dialog box will appear.
- Moreover, we will select Use a formula to determine which cells to format as the rule type.
- In addition, in the Format values where this formula is true box, we will type the following formula.
=AND($C5>TODAY(),SA1-TODAY()<=30)- This formula will find out the dates that are up to 30 days from today’s date.
- In addition, click on Format.
- Furthermore, click on Fill.
- In addition, select a color to format the cells.
- Here, we selected Yellow color.
- You can see the Sample of the color.
- Then, click OK.
- Afterward, you can see the Preview of the color in the New Formatting Rule dialog box.
- In addition, click OK.
- As a result, you can see the dates that are up to 30 days from today’s date have been marked with Yellow color.
- Therefore, we can create notifications or reminders for supply dates.
2. Combine IF and TODAY Functions To Generate Notifications
In this method, we will use the combination of IF and TODAY functions to create notifications or reminders in Excel. Using this method, we will find out notifications for the dates that are less than today.
Steps:
- In the first place, we will type the following formula in cell D5.
=IF(C5Formula Breakdown
IF(C5The TODAY function returns the date of today.Output: Date Expire
Explanation: Since the logical test of the IF function is true, it returns Date Expire.
After that, press ENTER.Therefore, you can see the result in cell D5.At this point, we will drag down the formula with a Fill Handle tool.
Therefore, you can see the notifications or reminders for the dates that are less than today’s date.
3. Merge IF, TODAY, and AND Functions to Create Reminders in Excel
In this method, we will merge IF, TODAY, and AND functions to create notifications or reminders in Excel. Here, we want notification or reminder No for the dates that are ahead of today, and Yes for the dates that are behind today.
Steps:
In the beginning, we will type the following formula in cell D5.
=IF(AND(C5<>"",TODAY()+7>=C5),"Yes","No")Formula Breakdown
The TODAY function finds out the date for today.The AND function finds out whether all conditions are true in a logical test.The IF function makes a logical comparison between a given data and the data we expect.IF(AND(C5<>””,TODAY()+7>=C5),”Yes”,”No”) becomesOutput: No.
Explanation: Since the logical test is not true, the formula returns No.
After that, press ENTER.Hence, you can see the result in cell D5.Furthermore, we will drag down the formula with the Fill Handle tool.
Hence, you can see the notification or reminder No for the dates that are ahead of today, and Yes for the dates that are behind today.
4. Apply Excel VBA Macros to Get Pop-Up Notification or Reminders
In this method, we will use VBA to create notifications or reminders in Excel.
Steps:
In the first place, we will right-click on the Sheet name >> select Visual Basic.Here, we will right-click on the Sheet in which we want the notification to pop up.
At this point, a VBA Editor window will appear.Furthermore, we will type the following code in the VBA Editor window.
Sub Reminder_date()
Dim date_col As Range
Dim due_date As Range
Dim pop_up_reminders As String
Set date_col = Range("D5:D9")
For Each due_date In date_col
If due_date <> "" And Date >= due_date - Range("D11") Then
pop_up_reminders = pop_up_reminders & " " & Due.Offset(0, -2)
End If
Next Due
If pop_up_reminders = "" Then
MsgBox "do not go for today"
Else: MsgBox "Contact these buyers " & pop_up_reminders
End If
End SubCode Breakdown
Here, we declare the Reminder_date as the Sub.We take Date_Col as Range, Due_date as Range, and pop_up_Reminders as String.For loop is used to run the code until it finds the last date.Else statement is used to set up a condition to show the notifications.
After that, Save the code >> Run the code.Therefore, you can see the pop-up notification in the Worksheet.
5. Add New Ribbon and Insert VBA to Obtain Notifications in Excel
In this method, first, we will insert VBA, and then, we will create a customized ribbon to assign the VBA. Afterward, every time we click on the customized ribbon, a reminder will pop up.
Let’s go through the following steps to do the task.
Step-1: Insert VBA
In this step, we will insert VBA.To do so, in the first place, go to the Developer tab >> select Visual Basic.This will open the VBA Editor window.Here, you can press the ALT+F11 keys to open the VBA Editor window.
At this point, from the Insert tab >> select Module.
Moreover, we will type the following code in the Module.
Dim time As Double
Dim message As String
Sub Pop_up_Notifications()
Dim what_time As String
If time = 0 Then
what_time = InputBox("when you want the reminder to Popup?")
If what_time <> "" And what_time <> "False" Then
message = InputBox("enter notification message")
On Error Resume Next
time = Date + TimeValue(what_time)
On Error GoTo 0
Application.OnTime Alarm, "Pop_up_Notifications"
End If
Else
Beep
Application.Speech.Speak message
MsgBox message
message = " "
time = 0
End If
End SubCode Breakdown
We take Pop_up_Notifications as the Sub.We take time as Double, message, and what_time as String.An Input box is used to input the time for notifications.If…Then statement is used to show the second message box.onTime Alarm method is used to show the notifications on time.Speech method is used to hear the notifications.
After that Save the code >> go back to the Worksheet.
Step-2: Add Customized Ribbon
In this step, we will add a customized ribbon to the Worksheet. Here, we want the customized ribbon in the View tab, beside the Macro group.
To do so, first, go to the File tab.
After that, from More >> select Options.
At this point, an Excel Options dialog box will appear.Then, from the Customize Ribbon >> go to the View tab >> expand the View tab.Furthermore, select Macros >> click on New Group.
Therefore, you can see a New Group under the Macro group.Next, we will rename this New Group.To do so, we will click on Rename.At this point, a Rename dialog box will appear.Then, we will type Notifications in the Display Name box >> click OK.
Now, it is time to assign the macro to the new Notification ribbon.Then, we will click on the drop-down icon in the Choose commands from box >> select Macros.
Then, we will select Pop_up_Notification which is the Sub of our code.Click on Add >> select Rename.
Then, we will select a Symbol to show the ribbon.Here, we select a Hand symbol.You can select any symbol according to your wish.In addition, click OK.
Therefore, you can see a Pop_up_Notifications ribbon in the View tab.Furthermore, we will click on Pop_up_Notifications.
After that, an Input box will appear.Here, we will input a time at which we want the notification >> click OK.
Along with that, another message box will appear.Then, we will type the message >> click OK.
Therefore, when the time of message comes, it pops up the message.Along with that, you will hear an audio of the message.Hence, we can create notifications or reminders in Excel.
Note: You must add the customized ribbon and assign the code if you want this method to work in your Excel sheet. Otherwise, downloading the above Excel file will not execute this method.Practice Section
You can download the following Excel file and practice the explained methods.
Conclusion
Here, we show you 5 easy methods to create notifications or remainder in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website Exceldemy for more related articles.