UserForm Date input as UK

[howey9]

I’m sure this has been asked a thousand times.

I have spent a couple of hours looking for the answer I need to no avail.

Can someone please tell me how I get the userform I have created to input the date in Uk format, and then recognise that it is a date once passed to the spreadsheet. Currently it will only work as intended if input as a US date.

Workbook attached.

[TMS]

Date validation isn't simple, IMO. It could be that all you need is:

Please Login or Register  to view this content.

However, if an American style date is input, it will be converted, so 3/14/15 will become 14/03/2015.

So, you might want to split the values and build a date before you convert it.

Regards, TMS

[mehmetcik]

I had to rebuild your userform to make this work.

Try the attached file.

[Leith Ross]

@ Trevor et al.,

VBA is American centric. Since the CDate function is Internationally aware. Your solution should work since it will check the user's locale when doing the conversion.

[skywriter]

Why not just use a date picker?

[TMS]

Thanks Leith

[Leith Ross]

Hello Trevor,

'S e do bheatha.

[TMS]

Ah, spilt coffee on your keyboard

[howey9]

Thanks for all the help guys.

mehmetcik that is spot on.