Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox/Rowsource - loses date/time format
Hi there, Hopefully a simple one. On a userform I have developed there are several comboboxes that use data on a worksheet as the rowsource. This data is in either date/time format. The list populates in the combo in date/time format, but once a value is selected, the value displayed is the actual number that corresponds with the selection, not the date itself (i.e. it loses the date/time formatting). i.e. user will 20/08/2006 when making a selection from the combo, once selected the user will see 38949. Does anyone know how to stop this occurring so that the date/time is always visible? Thank you Rob -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=566529 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox/Rowsource - loses date/time format
Hi Rob,
Try something like: '============= Private Sub ComboBox1_Change() With Me.ComboBox1 .Value = Format(.Value, "dd/mm/yy h:mm") End With End Sub '<<============= --- Regards, Norman "systemx" wrote in message ... Hi there, Hopefully a simple one. On a userform I have developed there are several comboboxes that use data on a worksheet as the rowsource. This data is in either date/time format. The list populates in the combo in date/time format, but once a value is selected, the value displayed is the actual number that corresponds with the selection, not the date itself (i.e. it loses the date/time formatting). i.e. user will 20/08/2006 when making a selection from the combo, once selected the user will see 38949. Does anyone know how to stop this occurring so that the date/time is always visible? Thank you Rob -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=566529 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox/Rowsource - loses date/time format
Hi Norman, Thank you for the help mate. It worked perfectly. The other method tha worked for me was to setup the source data as 'text', then format i after it was spat back out of the userform. Cheers Ro -- system ----------------------------------------------------------------------- systemx's Profile: http://www.excelforum.com/member.php...fo&userid=2925 View this thread: http://www.excelforum.com/showthread.php?threadid=56652 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource for Sheet ComboBox | Excel Worksheet Functions | |||
Combobox rowsource | Excel Programming | |||
How can Rowsource be used for a combobox on a form? | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
combobox rowsource | Excel Programming |