Message Box Comparison of Dates Condition

NEW POST:
I've thought more about this and decided to change my request and use some of what I already have in the vba. I've attached an updated workbook and need the current vba to allow for the following instead:
1-Show expire message if currently within 15 days from the end date unless have "X-" or "RX-" in the Status column for same row
2-Show renewal message if currently within 30 days from the end date, renewal message unless have "R-" or "RX-" in the Status column for same row
3-I need it to be possible to show both messages if currently within 15 days of end date if don't have any of the codes mentioned in #1 or #2.
4-Don't show either message if currently more than 30 days from the end date.

Possibilities depending on dates prior to end date and/or codes mentioned above:
Show renewal message but don't show expire message
Show renewal message and expire message
Don't show renewal message but show expire message
Don't show either message
Show both messages

Hopefully this simplifies my request. Thank you for your assistance.


------------------------------------------------------------------------------------------
ORIGINAL POST:
Good Morning, Excel Experts!

I'm hoping someone can help me with my issue. I've attached a sample spreadsheet (has two tabs but have the same purpose). I need an additional message box to popup when I first click on the Current Status Due Date field of the affected row (using the below conditions) AND after I click off of it either by pressing tab or pressing enter (using the below conditions).

Conditions:
-if Current Status Due Date is within 30 days or less prior to the End Date on same row
-Unless have "yes" in Current Status Due Date (date could be shown different ways but will always have a slash and a dash: ex. "m/d" or "m/d-yes" or "mm/dd-yes" or "m/dd-yes")

Your assistance is greatly appreciated.

Please Login or Register  to view this content.