Format in a combobox
Hi
I have again a problem whith format
i have yhis
Dim rng2 As Range
Set rng2 = Range(Range("Ark1!a1"), Range("ark1!a1").End(xlDown))
Me.combo_sedatoer.List = rng2.Value
The value in my range is date
And in the sheet the value is dd-mm-yyyy
But in the combobox the value are mm/dd/yyyy
I have try to use format "dd-mm-yyyy" but don't know where to do this
i get a error when i try
So maybe someone can help?
Alvin
|