Message Box - 15 days prior to Date

Frequent Contributor

Hello,

 

How could I make a msg box appear on the attached file when opening with a message box listing the Companies with dates 2 weeks from today for all columns that show [Amended] = "No"? 

 

Kindly see attached file. 

 

thank you

 

2 Replies

Hi,

I hope this is what you are meaning

=IF(C2="NO",IF((A2-TODAY())>=14,"More than two weeks","Less than two weeks"),"Amended")

You could use conditional formatting to highlight the rows that are two weeks away.

 

 

Hi Stonekiwi, thank you for the response. I sould have been more descriptive. I am looking for what I think is VBA where a message box would pop up on file open. I hope that makes sense. Let me know.

thank you