Thread: Pop Reminder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
 
Posts: 245
Default 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