Userform switch day with month

[IKZOUHETNIETWETEN]

My Userform switches the months and day somehow. My regional setting in windows are European (ddmmyyyy). But the userform fills in a date that has an english date format.I tried to change it with the CDate thing as you can see below. It works only if I fill in ALL txt boxes with CDate, but its giving me an error if I fill in only a few textboxes with the CDate: txtIN and txtEIND. How can I correct it? (I want date format dd/mm/yyyy) Its giving me the type mismatch. See attachment, press button to start. (fill in 'Unit', 'Datum In' and 'Eind Huur' Thanks! test.xlsm

Please Login or Register  to view this content.

[Norie]

Eh, the UK format is also ddmmyyyy.

Add code to check if the txtIN, txtOut are empty before using CDate.

Please Login or Register  to view this content.

[IKZOUHETNIETWETEN]

Still error, attachment: test.xlsm

[Norie]

Why didn't you add the check for the other date fields?

[IKZOUHETNIETWETEN]

Sorry, add the check for other date fields? I dont get it

[Norie]

You have 4 date fields/controls txtIN, txtOUT, txtSTART and txtEIND, you need to add a check for "" for each one of them, not just txtIN and txtOUT.

[IKZOUHETNIETWETEN]

Oh right, thanks! I got it working like this

Please Login or Register  to view this content.