Gettng a user form dropdown box to show a list of dates correctly for uk (DD/MM/YYYY)

[tonywatsonhelp]

HI Everyone,
I have a list of dates in my sheetand a bit of code that uploads them to a userform
the code is

Private Sub UserForm_Activate()  
ComboBox1.List = Range("names").Value
End Sub

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

 

[tonywatsonhelp]

Hi everyone,
don't worry, sorted it