combobox format
 

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

combobox format
 

Hi

Format cell(s) in desired time format.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Terry V" wrote in message
...
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

combobox format
 

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


---
Message posted from http://www.ExcelForum.com/