We can automate the complete process of creating notifications in Excel with VBA. Let’s say the payment due date of the customer is February 7, 2016 and we wish to create a reminder three days in advance. We first calculate the reminder date and then format the reminder date cells so that we can immediately see which clients need to be reminded about their payments. Also using automated systems we can email the reminder via Outlook, Gmail, Hotmail or Yahoo mail.
Watch the video below and then study the VBA code to learn how to make reminders or notifications in Excel using VBA:
You may like to watch this video on YouTube.
Dim i As Long, lastrow As Long
If Cells(i, 3) = Date Then
Cells(i, 3).Interior.ColorIndex = 3
Cells(i, 3).Font.ColorIndex = 2
Cells(i, 4).Value = “Send reminder”
Cells(i, 3).Font.ColorIndex = vbBlack
Cells(i, 3).Interior.ColorIndex = 2
Cells(i, 4).Value = “”