combobox format

[Terry V]

Hello
I have a combo box that displays "times" of the day.
After clicking the dropdown, the times show up as they should (in the format
I put them into the cells with).
However, after making the selection from the box, the time is displayed as
"the number it represents". How can I format the display in the combobox,
after the selection is made, to reflect the same format the numbers have
been placed into the cells with? --- hh:mm AM

Thank you
Terry

 

[Arvi Laanemets]

Hi

Format cell(s) in desired time format.

 

[mangesh_yadav]

might not be the best way but works. use this in the code for the
combobox control.

Private Sub ComboBox1_Change()

ComboBox1.Value = Format(ComboBox1.Value, "hh:mm:ss")

End Sub

- Mangesh