VBA code for "pop-up” message in VBA warning for due dates

[curious_Tanya]

Hello community,

I have a question and wondered if someone can help me with it.
I have Excel file with multiple tabs (with different loans and their maturity dates). I want to set up “pop-up” message in VBA warning me when due date in column “R” (always this column in each tab) is getting close to maturity date (7 calendar days) before. Something like “Attention, one of the loans is expiring within 7 days, please check!”.

Could someone please help with VBA code for this? I am struggling for a while now without success. Many, many thanks in advance!

 

[curious_Tanya]

Fantastic...it works! thank you so much! Have a nice day!

 

[sykes]

Pleasure! Thanks for the feedback.