Date handling from Userform to Excelsheet

All,

Had a look around the forum and I can't quite find the answer I am after (or that will actually take).

So my users put a date in UK format (dd/mm/yy) into a user form. This is then put into US format when it arrives in the Excel Sheet.

The element of interest throughout is DOI

Here is the Sub for the button press

Please Login or Register  to view this content.

The call is made to a module which has the following sub:

Please Login or Register  to view this content.

I have tried different forms of this: Cells(NextRow, NextColumn) = Format(DOI, "dd/mm/yy"), Cells(NextRow, NextColumn) = Format(cdate(DOI), "dd/mm/yy") and nothing is sticking.

I am looking at changing the input box to a date picker box but this is bugging me and I would like to fix it.

Thanks in advance

R

Hi rpjwhite,

Switching between US and European date formats can drive you crazy. When confronted with this problem I try to use a format that is common to both areas. If you format the spreadsheet to the month, day, and year format of your choosing, you will probably have success with the following:

Please Login or Register  to view this content.

Lewis

thread solved here:
http://www.excelforum.com/showthread.php?t=1173220