Restrict Text Format in Text box in Userform

[bala04msw]

Dear Forum,

I have developed an user form and keep one text box to fill date (date picker creates problem in my other team mates system, so i call off it). Now, i want to do few data validation measures for the particular text box.

1. Text box should be contained only numerical value (date)
2. The date inputs should be in dd/mm/yyyy format. (1.1.18 means, should be rejected)
3. The date should not be future date.

as per my code, 1 and 3 requirements are working perfectly. 2nd requirement only having issue. It shows. "Else without If error"

Kindly do the needful. Thanks in advance.

Please Login or Register  to view this content.

[Kaper]

Try:

Please Login or Register  to view this content.

[bala04msw]

Dear Mr. Kaper,

Thanks for your guidance on code. But not, none of the date format is accepting by the code. My requirement is, I want to have a date only DD/MM/YYYY in this format. I dont want even d.m.yyyy or dd.mm.yyyy date format.

Kindly do the needful.

Regards

[Kaper]

Have you tested my code? (Of course I didn't because there was no test file attached).

If not - do the test.
If yes and it do accept wrong formats, provide sample file wiyth sample form.

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[bala04msw]

Dear Mr.Kaper,

As you suggested, i have attached the workbook with your code. Its not allowed any date value or format. Kindly do the needful.

Thanks in advance

[Kaper]

Hi,

I expect the code provided shall work fine if there are standard international settinmgs in system. May be you have national settings with different format date?
You may try using Regular Expresions to test date format. This shall work independently on regional settiongs in system. For instance:

Please Login or Register  to view this content.