Private Sub Combobox1_Click()
Combobox1.Value = format(Combobox1.Value,"hh:mm:ss")
End sub

--
Regards,
Tom Ogilvy


"sam1" wrote in message
...

Thanks for info, I'm tring to put Times in the combo box but when i
select time values, they convert to numbers in the combobox, how do i
keep the Time format?


--
sam1
------------------------------------------------------------------------
sam1's Profile:
http://www.excelforum.com/member.php...o&userid=18280
View this thread: http://www.excelforum.com/showthread...hreadid=526857