Notifications on excel [Solved/Closed]

- - Latest reply:  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
See more 

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
928
0
Thank you
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
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
915 -
See this one
http://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//.