Simple Question

[cmk18]

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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"cmk18" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>