Date problem from code to text box to spreadsheet

J

Joe 90

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?
 
M

Media Lint

I suspect it is getting transposed when you pass the
argument.

Stop testing with that date ... use something which can
ONLY work one way: October 31, for example. That way
you'll be able to easier track down the real problem since
you should get an ERROR where it fails.
 
H

Harald Staff

How is it passed ?
Sheets(2).Cells(14, 3).Value = Datevalue(Textbox1.Text)
should interprete according to your regional preferences.
 
Top