Hi,
I have a simple userform with one textbox -
InDate
With the following code
If I enter 1/5/05 (UK format so 1 May 2005) into the InDate textbox, cell A1 on my spreadsheet shows the value "05/01/05" - 5 January 2005)
I have my Windows settings on UK format, the cell is formatted as "dd/mm/yyyy"
Can anybody help - I have tried all ways to fix this and nothing seems to work. This is needed for a larger VBA project I am working on.
I am running Windows 2000, Office 2000, I have tried this on two PCs with the same problem on each.
Thanks for any help...
Ade
I have a simple userform with one textbox -
InDate
With the following code
Code:
Private Sub InDate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Worksheets("Sheet1").Range("A1") = InDate.Value
End Sub
If I enter 1/5/05 (UK format so 1 May 2005) into the InDate textbox, cell A1 on my spreadsheet shows the value "05/01/05" - 5 January 2005)
I have my Windows settings on UK format, the cell is formatted as "dd/mm/yyyy"
Can anybody help - I have tried all ways to fix this and nothing seems to work. This is needed for a larger VBA project I am working on.
I am running Windows 2000, Office 2000, I have tried this on two PCs with the same problem on each.
Thanks for any help...
Ade