Notifications on excel [Solved/Closed]

Jebin - Nov 14, 2011 at 05:36 AM - 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 

5 replies

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Nov 14, 2011 at 09:32 PM
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 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Dec 1, 2011 at 07:05 AM
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//.