Hi Forum.

I am really struggling with the date formatting of a textbox on a userform playing silly sods when transferring the data to a cell...
I need a dd/mm/yyyy format, however If I run the user form and add a date of 01/05/2014 to the textbox it applies to the cell as 05/01/2014, however, when I added 26/06/2014, it added correctly - any idea's?
Here's what I've got:

Private Sub TxtBxDate_Change()
ThisWorkbook.Sheets("Supplier Order Log").Range("E3").Value = TxtBxDate.Value
End Sub
with
Private Sub UserForm_Initialize()
TxtBxDate.Text = Format(Date, "dd/mm/yyyy")
End Sub
And my cell E3 on the "Supplier Order log" Sheet is formatted as Date, as dd/mm/yyyy

It appears that if the 'Day' number is smaller than 12, then it seems to assume that it is a month rather than a day - would that be what it's doing? I played around with a number of different dates using smaller days, but as soon as I add 13/12/2014 it formats correctly.
Also, I think I've just noticed that it keeps auto updating the date to todays date?.... Maybe not though, it might be doing something as I'm playing around with it....

Please help - any better solutions would be much appreciated.

Thanks in advance, guys!