J
jennie
Hi,
I am having a problem with the date formatting in a user form text box
in excel 2000.
For example:
If in the text box you type: 03/12/04 for the 3rd december 04
The following code writes the date back to the active cell
ActiveCell.Value = Format(Me.txtDate.Value, "dd/mm/yy")
However this writes 12/03/04 onto the worksheet.
How do I get it to recognise that 03 is the day and 12 the month?
Thanks
Jenni
I am having a problem with the date formatting in a user form text box
in excel 2000.
For example:
If in the text box you type: 03/12/04 for the 3rd december 04
The following code writes the date back to the active cell
ActiveCell.Value = Format(Me.txtDate.Value, "dd/mm/yy")
However this writes 12/03/04 onto the worksheet.
How do I get it to recognise that 03 is the day and 12 the month?
Thanks
Jenni