Simple Question
 

I have a combobox in a userform that selects a time. The issue is when
you select a time, it shows up as a serial time and not in a #:##
format. I don't see anything in the properties that seems to address
this.

Cheers-
Chris Krahe


--
cmk18
------------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=397193

Simple Question
 

Private Sub Combobox1_click()
ComboBox1.Value = Format(ComboBox1.Value, "hh:mm")
End Sub

--
Regards,
Tom Ogilvy


"cmk18" wrote in
message ...

I have a combobox in a userform that selects a time. The issue is when
you select a time, it shows up as a serial time and not in a #:##
format. I don't see anything in the properties that seems to address
this.

Cheers-
Chris Krahe


--
cmk18
------------------------------------------------------------------------
cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=397193