Message Box - 15 days prior to Date

%3CLINGO-SUB%20id%3D%22lingo-sub-2424353%22%20slang%3D%22en-US%22%3EMessage%20Box%20-%2015%20days%20prior%20to%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424353%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20could%20I%20make%20a%20msg%20box%20appear%20on%20the%20attached%20file%20when%20opening%20with%20a%20message%20box%20listing%20the%20Companies%20with%20dates%202%20weeks%20from%20today%20for%20all%20columns%20that%20show%20%5BAmended%5D%20%3D%20%22No%22%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%20see%20attached%20file.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2424353%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2424565%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Box%20-%2015%20days%20prior%20to%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424565%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20hope%20this%20is%20what%20you%20are%20meaning%3C%2FP%3E%3CP%3E%3DIF(C2%3D%22NO%22%2CIF((A2-TODAY())%26gt%3B%3D14%2C%22More%20than%20two%20weeks%22%2C%22Less%20than%20two%20weeks%22)%2C%22Amended%22)%3C%2FP%3E%3CP%3EYou%20could%20use%20conditional%20formatting%20to%20highlight%20the%20rows%20that%20are%20two%20weeks%20away.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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