Expiring date with message box

[woobinhyul]

Good Morning to all!
I am new to excel VBA and my excel in office is 2010 version, may I ask a help to you guys about VBA.
Can someone teach me how to do a message box with all my expiring date, items that it will expire in a month before the expire date, and the message box will show until the day before it expires.
Hoping someone care to help. Thank you from Philippines.

 

[Skyybot]

When do you want the MsgBox to display? Do you have a button? Do you want it to display when the Workbook is opened? Where is the data coming from?

 

[woobinhyul]

When do you want the MsgBox to display? Do you have a button? Do you want it to display when the Workbook is opened? Where is the data coming from?

Good Morning sir, just a list of dates, and when the dates comes I want something to prompt me that the list of dates will be expiring soon, maybe a month before it expires, and I want some msgbox of all the list of my listed dates that will expire month before the expired date listed.
No, i don't have a button.
Yes, everytime I open the workbook.

 

[Skyybot]

Great! Can you share a copy of your Workbook using XL2BB?

 

[woobinhyul]

Great! Can you share a copy of your Workbook using XL2BB?

Just like that sir, simple list of dates that I manually input all the dates if it's due, I just want some msgbox to prompt me or alert me that some items of mine are expiring.

 

[Skyybot]

Great! What Column are the dates in?

 

[woobinhyul]

Great! What Column are the dates in?

anywhere you like sir, i will just follow your command. i just know how to do msgbox, but with expiring dates I don't know how to create the code.

 

[Skyybot]

Oh. Do you know how to use IF THEN statements?

 

[Skyybot]

Or LOOPs?

 

[woobinhyul]

Oh. Do you know how to use IF THEN statements?

If Function in excel or in vba? in excel then yes, in vba no, i don't know how to use it.

Or LOOPs?

i dont know loops sir, knew to vba, still studying it.