Dateformat in a combobox

Hello,

I have a combobox, see Picture. How do I change the format so the combobox will display the format on the top row?

Cheers Raffe

DateCombobox.jpg

How are you assigning the listfillrange? is this using name manager because the combobox should match the formatting of that range

Hello Dave, I fill it like this. Can I change the format in the combobox in some way?

Cheers Raffe

With ThisWorkbook.Sheets("Main").TimeFrom
.Clear
.Value = ""
.List = ThisWorkbook.Worksheets("Data").Range(DataCombo).Value
.SelText = ThisWorkbook.Sheets("Data").Range("A2")
End With

Is your range DataCombo formatted as you have asked for in your OP?

Yes, it is format as:

電電-MM-DD tt:mm:ss,0

So why does the combobox show date with PM?

try format as

電電-MM-DD tt:mm:ss

But I would like to have the resolution ms.

Hrmm, you might be able to use a private sub for combobox change event to format but not sure why you'd need to do it there as well.

How do I do that?

Please Login or Register  to view this content.

or if that fails try:

Please Login or Register  to view this content.

It did not work. I use the Active-x Control, does it matter?

Can you use form control?