I have a textbox on a userform in which I set the date with code -
format(date,"dd-mm-yy")

This looks fine on the form.

The value of the textbox is then passed to a spreadsheet cell,which is
preformatted with the same date format.

However 10-12-03 (10th December) comes out on the spreadsheet as 12-10-03
(12th October)

to fix this I have recorded as format(date,"mm-dd-yy"), which works but this
is not right surely.

All regional settings are UK English .

Any suggestions?