Notifications on excel

Solved/Closed
Report
-
 jd -
Hello,



I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry date on another cell , there must be a notification stating expiry for customer A. Is it possible there may be separate pop ups for each customer. This should happen when excel is opened. It would be of great help if you may help me.

Thanks in Advance.

God Bless,

Jebin

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
post a very small extract of sheet and explain your needs.
use speedyshare.com for uploading you sample file
[code]http://speedy.sh/N2k9D/Example.xlsx/code
http://speedy.sh/N2k9D/Example.xlsx

Please find the upload link.

What I would like to know is that when I open this excel file is it possible to get a pop up notification. Notifications have to be 90 days prior, then 60 days then 30 days. It can say customer E us due for renewal. Or is there a better / easier way.

Thanks in advance
[code]http://speedy.sh/N2k9D/Example.xlsx/code
http://speedy.sh/N2k9D/Example.xlsx

Please find the upload link.

What I would like to know is that when I open this excel file is it possible to get a pop up notification. Notifications have to be 90 days prior, then 60 days then 30 days. It can say customer E us due for renewal. Or is there a better / easier way.

I appreciate all your help
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
See this one
https://ccm.net/forum/affich-284806-codes-for-reminder-creation-in-excel-vba

you would need to modify the script to suit your need. this is to just to give you a good basis to start
Thanks a lot//.