Checking Date in Macro Code

I have a spreadsheet that I created that we use as our Invoice. I have created a macro button that does certain checks/balances when it is pressed, after the invoice has been created. One of the common problems was that the employees would forget to put a date on the invoice. So now, I have the code for that:

Please Login or Register  to view this content.

But now, I want to go one step further. In addition to checking to see if there is somthing in the field, I want it to check to make sure that the date entered is TODAY and if it's not, to popup with a MSGBOX that says, "Are you sure you want to enter a date other than today?". If they enter yes, the code proceeds with the checking. If they enter No, I want the program to stop running and to go to that field D5 and wait for the user to correct the date. As a newbie, I'm just unclear what function to use. I've tried various things, all to no avail. Can anyone help me? Thank you!

Hello mmwtx,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.
3. You can also do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

In addition, please amend your thread title.

Thank you for adjusting my post as needed. I didn't realize I needed to do that. I'm happy to change my thread title; but can find no where that lists instructions on how to do that. Thanks for the help!

Hello mmwtx,

To change a Title on your post, click EDIT then Go Advanced and change your title.

Hello mmwtx,

To change a Title on your post, click the EDIT button then the Go Advanced button and change your title.