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
The call is made to a module which has the following sub:
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
Bookmarks