Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Date ComboBox | Excel Discussion (Misc queries) | |||
OFFSET for multiple columns & combobox format | Charts and Charting in Excel | |||
Number format for Combobox | Excel Discussion (Misc queries) | |||
ComboBox Format Problem | Excel Programming | |||
Format Display in ComboBox | Excel Programming |