Type mismatch on a date textbox when leaving it blank

Hi guys, I wonder if you can help me.

I have a form with two TextBox corresponding to dates. The first one is mandatory, and a valid date has to be entered. The second is optional: it could be blank or if not, a valid date must be entered.

I tried to do it with DTpickers, but this solution doesn't work well on all Excel versions. So I decided to do it with simple textbox. But if the second date textbox is left empty, I got the "type mismatch" error message. If I defined it as variant instead of date it works well although I can't avoid the user enter a wrong date. Besides, I have another problem, as the date format must be dd-mm-aa, and this only works if the user enter a valid date on mm-dd-aa format (the default format for VB).

This is the code:

Please Login or Register  to view this content.

Thanks in advance for your suggestions.

Thanks a lot Holger & Robert, I didn't know about the Cdate tool.