User Form field inserts wrong date format

Hello there team.

I have cobbled together (borrowing from examples I have found online because I don't know VBA) a form which inserts a date into a spreadsheet.

The trouble I have is that this date field is in USA date format and I need UK.

If I enter 03/01/2009 into the form, it appears in the spreadsheet as 01/03/2009. I have formatted these cells to display the month only and because of the way it was entered, the next column displays MAR instead of JAN.

Any ideas?

Can I validate the input value in a form?


Thanks for all your help as usual, you guys rule!