pop-up message box expired dates

[calebruiz]

Hello everyone,

I'm currently doing my internship and my assignment is to create a dashboard for a company of all their certified assets. I have 7 sheets that have multiple tables with certificates and their expire dates. Below you will find an example of one of the many tables:

Instrument ID	Range	Serial nr	Calibration date	Expire date	Status
01-116-0001	0-50	1234	14-Aug-2019	14-Aug-2020	Expired
01-116-0002	50-100	2345	12-Sep-2020	12-Sep-2021	Expired
01-116-0003	100-150	3456	15-Apr-2021	15-Apr-2022	Certified
01-116-0004	150-200	4567	9-Oct-2020	9-Oct-2021	Expired
01-116-0005	200-250	5678	21-Jan-2021	21-Jan-2022	About to expire
01-116-0006	250-300	6789	5-Jul-2021	5-Jul-2022	Certified
01-116-0007	300-350	7890	19-Jan-2021	19-Jan-2022	About to expire

The 'Status' column automatically changes to 'About to expire' when the date is 30 days away from expiring.

Now, I want a pop-up MsgBox every time the excel workbook is opened saying which certificate is about to expire and which expired already. See attached picture:

Is there a code in VBA that I can apply for all tables on every sheet? Please let me know.

Kind regards,
Caleb

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Message box for expired dates from multiple sheets
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.