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