Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
simple question, hopefully a simple answer! | Excel Programming | |||
A simple question | Excel Programming | |||
Simple Question | Excel Programming |