VBA - Pop alert for list of dates

PT_ANCF

New Member
Joined
Mar 18, 2019
Messages
13
Hello all,


First of all, I tried to find a similar thread but without much success (as I'm new) for my question. So sorry, if there is already a similar thread and if yes and you have it, just point me to the right direction. Thank you.


So I have a list of client contracts and I would like to have a pop-alert running through VBA that would give me an alert. For example:







In this case, I would like for a pop up tab to appear with the clients that, in column E, are -3 months from the End date (column D) with a message like "Renewal meeting with Client(s) x and y" e.g.


I have the idea that it's possible as I've seen it for one single cell but I would like the alert to catch all the contracts that are -3months. Is this possible?


Thank you so much for the aid.


Best regards,
PT_ANCF
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,727
Office Version
2013
Platform
Windows
So in your example what would your message Box popup look like.

Would it be:

Red
Blue

Show me some real examples of where date is I assume you mean less then 90 days.

Which of your examples show above would result in a popup?

We need to use like 90 days not 3 months since various months have various number of days.
 
Last edited:

PT_ANCF

New Member
Joined
Mar 18, 2019
Messages
13
Hi My Answer is This,

I want the pop up box to appear with something like (if possible):

"Renewal alert, clients:
-Yellow
-Blue"

And yes, i mean 90 days. So for example, if the end date it's the 31st of December I want the alert to pop up (starting at) 90 days before.

In my example Yellow and Blue should appear as Yellow is expired (passed the end date) and Blue is expiring (passed the 90 days).

By the way, while I was writing this and thinking of how it would work. Is it possible to define a way to stop a client to appear in the pop up?

For example, I know Yellow is expired and Im already negotiating a new contract so I don't need for it to keeping popping up.

Thank you so much.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,727
Office Version
2013
Platform
Windows
You said:
For example, I know Yellow is expired and Im already negotiating a new contract so I don't need for it to keeping popping up.
My question:
How would the script know you know this?
Hi My Answer is This,

I want the pop up box to appear with something like (if possible):

"Renewal alert, clients:
-Yellow
-Blue"

And yes, i mean 90 days. So for example, if the end date it's the 31st of December I want the alert to pop up (starting at) 90 days before.

In my example Yellow and Blue should appear as Yellow is expired (passed the end date) and Blue is expiring (passed the 90 days).

By the way, while I was writing this and thinking of how it would work. Is it possible to define a way to stop a client to appear in the pop up?

For example, I know Yellow is expired and Im already negotiating a new contract so I don't need for it to keeping popping up.

Thank you so much.
 

PT_ANCF

New Member
Joined
Mar 18, 2019
Messages
13
You said:
For example, I know Yellow is expired and Im already negotiating a new contract so I don't need for it to keeping popping up.
My question:
How would the script know you know this?
I have a column, as in the example with the ending date of the contracts. this is manual input. So the script the would read the end date column and check (in the range) if the the date for that column is =< than 90 days.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,727
Office Version
2013
Platform
Windows
This is now getting to confusing for me.

The original post I thought you said depended on Dates in Column D and E

So a script can do that.

But then you said if I already know this some how tell the script to not tell me this.
So I'm now confused.
 

PT_ANCF

New Member
Joined
Mar 18, 2019
Messages
13
Sorry, i'm not expressing myself right.

Simplifying and by parts:

1st) If cell in column E is =< than 90 days to cell in column D then pop up message saying for example "Renew Blue" (clients in columns A)

This for all clients and their dates (if more than one client pop up will be "Renew Blue and Yellow)


2nd) Is it possible to define the script (for example with an extra column I) to have a command that "if cell in I is ticked even if E is=< 90 days D, pop up wont return client".


Was i more clear? Sorry for the confusion and thank you.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,727
Office Version
2013
Platform
Windows
You said:
"if cell in I is ticked

Define ticked.

I have been using Excel for years but do not know how to tick a cell
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,727
Office Version
2013
Platform
Windows
You may be getting tired of all my question. But how are you going to put a checkbox into a cell.

Why not something simple like put "I know" in column I

To put a check Mark not Checkbox

You would have to use a special font like maybe Weddings and then enter the character "a" to get a check mark
 

Watch MrExcel Video

Forum statistics

Threads
1,089,764
Messages
5,410,287
Members
403,308
Latest member
JasonTheGreat

This Week's Hot Topics

Top