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
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,279
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,279
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,279
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,279
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,279
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
 

Forum statistics

Threads
1,082,246
Messages
5,363,998
Members
400,773
Latest member
jwolfe

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top