day and month switching in VBA userform

Hi,

I have created a userform that contains text boxes and command buttons. When I enter a date dd/mm/yyyy through the userform it displays as mm/dd/yyyy on the worksheet. I have the cells formatted to date, locale English (U.K.), however this still switches the date.

Is is possible to specify the date format in both the VBA userform and then in the column in the worksheet , to keep the date as dd/mm/yyyy



I've also seen that you can do something along the lines of :

Dim mydate As Date
mydate = sesdatetext.value
.Cells(lRow, 8).Value = mydate

However, I can't seem to get this to work..

Attached is the workbook, any ideas/corrections are welcome!

Thanks, WWM