Date problem from code to text box to spreadsheet

  • Thread starter Thread starter Joe 90
  • Start date Start date
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?
 
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.
 
How is it passed ?
Sheets(2).Cells(14, 3).Value = Datevalue(Textbox1.Text)
should interprete according to your regional preferences.
 
Back
Top