Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reminder | Excel Discussion (Misc queries) | |||
Reminder | Excel Worksheet Functions | |||
Reminder | Excel Worksheet Functions | |||
Reminder | Excel Discussion (Misc queries) | |||
Pop-Up Reminder | Excel Discussion (Misc queries) |