Display time in Combobox

[dave8]

I have a Combobox that displays time values. My cells on the worksheet is set to custom as h:mm and the values are 24/hr clock. I have to convert the values to format(combobox1.value, "h:mm"). This works except that when I select "6:00:00 am" on the dropdown, is displayed as "0:25" and "12:00:00 PM" is displayed as "0:05".

Can someone help me figure this out?

 

[Jerry Sullivan]

Hi Dave,

You might be using a Form Control on a worksheet.

If you use an ActiveX control on a worksheet then you can use the ComboBox_Click event to reformat the displayed value immediately after it is selected.

 

[dave8]

Hi Dave,

You might be using a Form Control on a worksheet.

If you use an ActiveX control on a worksheet then you can use the ComboBox_Click event to reformat the displayed value immediately after it is selected.

I am using an ActiveX control on a worksheet and my code is in the Combobox_Click event. All the values are fine with the exception of 6:00:00 AM and 12:00:00 PM.

 

[Jerry Sullivan]

If you are using rowsource to link the list items, perhaps check that the values and formatting of those two cells is consistent with the others.