Notifications on excel

Solved/Closed
Jebin - Nov 14, 2011 at 05:36 AM
 jd - Dec 1, 2011 at 10:57 PM
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 14, 2011 at 09:32 PM
post a very small extract of sheet and explain your needs.
use speedyshare.com for uploading you sample file
0
[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
0
[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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2011 at 07:05 AM
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
0
Thanks a lot//.
0