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

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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