Pop up message in excel (like outlook agenda)
Closed
Marliesjuh
Posts
1
Registration date
Wednesday December 22, 2010
Status
Member
Last seen
December 22, 2010
-
Dec 22, 2010 at 04:22 AM
Yogiraj Posts 1 Registration date Wednesday December 29, 2010 Status Member Last seen December 29, 2010 - Dec 29, 2010 at 08:55 AM
Yogiraj Posts 1 Registration date Wednesday December 29, 2010 Status Member Last seen December 29, 2010 - Dec 29, 2010 at 08:55 AM
Related:
- Get pop up window alert in excel when a date is reached
- Excel date format dd.mm.yyyy - Guide
- Pop up reminder message in excel - Excel Forum
- Pop up reminder in excel free download - Download - Spreadsheets
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Screenshot in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Dec 23, 2010 at 10:29 AM
Dec 23, 2010 at 10:29 AM
Hi Marlies,
This is what I have come up with.
Since you didn't provided any sample data I have used the following:
In which column A is first name, Column B is Last name, Column C is reminder date, D1 is today's date using formula: =TODAY().
Open VB and paste the following code under ThisWorkbook:
When you close your workbook now, you will get message box after message box each with first and last name of the people you need to e-mail.
Best regards,
Trowa
This is what I have come up with.
Since you didn't provided any sample data I have used the following:
a b 23-12-2010 23-12-2010 aa bb 24-12-2010 aaa bbb 23-12-2010
In which column A is first name, Column B is Last name, Column C is reminder date, D1 is today's date using formula: =TODAY().
Open VB and paste the following code under ThisWorkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean) Set MR = Range("C1:C3") For Each cell In MR If cell.Value = Range("D1").Value Then MsgBox (cell.Offset(0, -2).Value & " " & cell.Offset(0, -1)) Next End Sub
When you close your workbook now, you will get message box after message box each with first and last name of the people you need to e-mail.
Best regards,
Trowa