VBA Date Validation?

[jsabo]

Hello,

Trying to user-input-error-proof a new macro w/ UI that I'm building in Word. As far as I can tell, I am unable to use an input mask... So i have the default value of the field as "DD-MMM-YYYY" to clearly hint for the user. But, I would still like to have validation that passes/fails if the user inputs correctly/incorrectly.

Here's what I'm trying so far just to test in a separate file:

Please Login or Register  to view this content.

Not really my first preferred go-to, but I think it could be sufficient. This would validate that a date is entered like "05-Mar-2014". Any other suggestions or am I close to makine this work? Cheers.

[lancer102rus]

need this?

Please Login or Register  to view this content.

[jsabo]

So, is it that simple? If the user puts ANY date format in a text box... and I declare oDate to be a Date... then I can simply change the way the VBA displays it?

[lancer102rus]

Yes. It is so.

[jsabo]

Thanks for your help!

[jsabo]

So, here is where I am now:

Please Login or Register  to view this content.

First the code looks to see if it's actually a date that's input. If not, it forces the the user to put in a date. Then I try to assign the value of the text box to a certain variable and dictate the format "DD-MMM-YYYY". But, whenever the date is spit out it is not DD-MMM-YYYY, rather M/D/YY. Any ideas?

EDIT:

Got it working here, this makes more sense and is more efficient too:

Please Login or Register  to view this content.