Pop up reminder
Closed
djandpj
TrowaD
- Posts
- 2
- Registration date
- Thursday October 18, 2012
- Status
- Member
- Last seen
- October 18, 2012
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Excel due date reminder template download
- Popup reminder in excel template - Best answers
- Membuat pop up reminder excel - Best answers
- DUE DATE REMINDER IN EXCEL TO NEW SHEET? ✓ - Forum - Excel
- Due date reminder in excel 07 ✓ - Forum - Excel
- How to get xls due date reminder alert email - Forum - Office Software
- Due date reminder ahead of one month and mail that to customers? - Forum - Excel
- Pop up reminder of expiry date - Forum - Office Software
3 replies
djandpj
Oct 18, 2012 at 09:40 AM
- Posts
- 2
- Registration date
- Thursday October 18, 2012
- Status
- Member
- Last seen
- October 18, 2012
Oct 18, 2012 at 09:40 AM
Is it possible to have a pop up reminder when a item date is due within a designated number of days plus items due 5 days in the future.
I want to set up a reminder in excel, this reminder must pop and show due date and item up 5 days before the due date Can I Create A Reminder To Pop Up In Excel 5 Days Before? .... Excel 2007
Thanks for your interest.
djandpj
I want to set up a reminder in excel, this reminder must pop and show due date and item up 5 days before the due date Can I Create A Reminder To Pop Up In Excel 5 Days Before? .... Excel 2007
Thanks for your interest.
djandpj
TrowaD
Oct 18, 2012 at 09:06 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 18, 2012 at 09:06 AM
Hi Djandpj,
What do you mean by "5 day pop up reminder"?
Please explain in more detail.
Best regards,
Trowa
What do you mean by "5 day pop up reminder"?
Please explain in more detail.
Best regards,
Trowa
TrowaD
Oct 18, 2012 at 10:26 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 18, 2012 at 10:26 AM
Hi Djandpj,
I don't want to sound like a pain in the behind area, but you are still not very clear.
All you ask is: "Is it possible" and "Can I".
So to answer your questions, the answer is yes.
Try to give some more relevant info like where the dates are located on the sheet and when do you want to be reminded (when you open the file, open the sheet, manually run code, etc....)
Here is a simple code which checks the date in A1 and compares it to today's date. When there is 5 or less days to go a popup appears. The is done whenever the sheets containing the date in A1 is activated.
To implement the code, right-click on the sheets name and select "view code", paste code on big white field.
Best regards,
Trowa
I don't want to sound like a pain in the behind area, but you are still not very clear.
All you ask is: "Is it possible" and "Can I".
So to answer your questions, the answer is yes.
Try to give some more relevant info like where the dates are located on the sheet and when do you want to be reminded (when you open the file, open the sheet, manually run code, etc....)
Here is a simple code which checks the date in A1 and compares it to today's date. When there is 5 or less days to go a popup appears. The is done whenever the sheets containing the date in A1 is activated.
Private Sub Worksheet_Activate() If Range("A1").Value - Date <= 5 Then MsgBox "5 or less till due date" End If End Sub
To implement the code, right-click on the sheets name and select "view code", paste code on big white field.
Best regards,
Trowa