| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
time serial number problem
Private Sub ComboBox1_click()
ComboBox1.Value = Format(ComboBox1.Value, "hh:mm:ss") End Sub Might work depending on your settings. -- Regards, Tom Ogilvy "fordge23" wrote in message ... I have a combo box on a userform that is tied to cells in an excel spreadsheet that lists times. When the cell is displayed in the combo box it converts it to serial code. I want the box to display the time. Help? SDC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up part of a number within a serial number and cpy back assoc | Excel Worksheet Functions | |||
| Time Serial | Excel Discussion (Misc queries) | |||
| time serial number | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| How Do I Eliminate the Serial Number for time from Date? | Excel Discussion (Misc queries) | |||
Hybrid Mode
