Requesting help to create pop up reminders in Excel...

[ssmith01]

Hello. My first post here. I need assistance in creating an Excel spreadsheet. Here is what I am trying to accomplish:
I need the spreadsheet to include: name of a vendor, address, email, Form Rec'd, Form Expires, and finally, a column that will create a reminder pop up to: Send email to vendor for Form Renewal (maybe 30 days prior to the Form Expires date). Can anyone help? Thank you in advance.

[MatrixMan]

ssmith01.xlsm

hi ssmith ... are you sure you need a message to pop up? if you imagine you have a spreadsheet with the info you've listed and there are 100 lines of data, what would make the message pop up? something would have to happen to trigger the pop up and - even if you evaluated the form expires date when someone opened the file or activated the sheet you would either get a pop up message saying the following 25 forms are about to expire or you'd get 25 pop ups. have you thought about using conditional formatting to highlight the rows based on how close the form expiry date is? i.e. it could be shaded red if the date is within 10 days, amber if within 30, etc etc. you also need a column with a flag or date to indicate the form has been processed (or just remove the expiry date) so those rows can be ignored.

Anyway - attached is a file with both options; the spreadsheet itself has the visual "alert" based on conditional formatting and you'll see that when the sheet is activated, a bunch of annoying pop ups come up to tell you which ones are approaching the expiry date.

[ssmith01]

MatrixMan...thank you so much! Have a great day!