Expiring date with message box

woobinhyul

New Member
Joined
Jan 26, 2023
Messages
5
Office Version
  1. 365
  2. 2010
  3. 2007
  4. 2003 or older
Platform
  1. Windows
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.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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?
 
Upvote 0
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.
 
Upvote 0
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.
 

Attachments

  • 1.png
    1.png
    9 KB · Views: 11
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top