here i am looking for date reminder for current and previous day.
here is the code for current day reminder. but don't know what to do reminder for previous day (YESTERDAY).
any help or suggestion is most appreciated.
...Marc
[VBA]Option Explicit
Dim cl As Range
Private Sub ListBox1_Click()
Set cl = Sheet1.UsedRange.Find(Me.ListBox1.Value, LookIn:=xlValues)
cl.Select
End Sub
Private Sub UserForm_Initialize()
Dim rDates As Range
the above given code pop up the message for current due date i.e.: 11/08/2011.
meantime i want to pop up the message for previous due date (overdue date), i.e. 11/07/2011.