tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
HI Everyone,
I have a list of dates in my sheetand a bit of code that uploads them to a userform
the code is
this works great but the formatting is wrong,
it shows the dates like this 1/9/2020 m/d/yyyyy
ut i'm in the uk and need the zeros so i need 09/01/2020 dd/mm/yyyy
how can i get this to show correctly?
Thanks
Tony
I have a list of dates in my sheetand a bit of code that uploads them to a userform
the code is
VBA Code:
Private Sub UserForm_Activate()
ComboBox1.List = Range("names").Value
End Sub
it shows the dates like this 1/9/2020 m/d/yyyyy
ut i'm in the uk and need the zeros so i need 09/01/2020 dd/mm/yyyy
how can i get this to show correctly?
Thanks
Tony