When entering the date from a form I have to enter as MM/DD/YY even though the sheet is formatted to English(Australian) I need it to be entered correctly as the date is used in a sort.

Is there any way to code :- txtInvDate.Text = Cells(Cr ,5).value [The textbox input] so that it can be entered as DD/MM/YY?

Also can it be error checked to make sure it's been entered in the correct format?

I cannot use any formula on the sheet itself as the code checks for the next empty row and does not consider a row with a formula as empty.