Pop Reminder
Change Ranges to suit and bobs your uncle.
Sub Pop()
Dim PopDate As Range
Dim DueDate As Range
Set PopDate = Range("A1")
Set DueDate = Range("B1")
If PopDate = DueDate - 3 Then
MsgBox "Riminder goes here"
End If
End Sub
"tmdrake" wrote:
I have a excel spreadsheet that contains the date a request is received and
the date the request is due to the customers. How do I create a popup that
alerts the user three days prior to the due date, which request are due? I
will need for the popup to activate everytime the spreadsheet is opened.
Thanks you much
--
tmdrake
|