Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Display in ComboBox
Hello-
I have a combobox that is pulling a rowsource from a named range of dates (1/12003, 1/2/2003, etc). The list displays fine, but when you select one it shows up in the box as the value of the date (eg 37712). Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Display in ComboBox
Try browsing through the answers provided by this search.
http://www.google.com/groups?as_q=Fo...n&num=50&hl=en HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Hello- I have a combobox that is pulling a rowsource from a named range of dates (1/12003, 1/2/2003, etc). The list displays fine, but when you select one it shows up in the box as the value of the date (eg 37712). Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Display in ComboBox
Private Sub Combobox1_Click()
Combobox1.Value = Format(cDate(combobox1.Value),"m/d/yyyy") End Sub -- Regards, Tom Ogilvy "King" wrote in message news:vzAib.752439$YN5.705646@sccrnsc01... Hello- I have a combobox that is pulling a rowsource from a named range of dates (1/12003, 1/2/2003, etc). The list displays fine, but when you select one it shows up in the box as the value of the date (eg 37712). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Date ComboBox | Excel Discussion (Misc queries) | |||
format combobox in userform to accept dates | Excel Worksheet Functions | |||
Combobox display on startup | New Users to Excel | |||
Number format for Combobox | Excel Discussion (Misc queries) | |||
Combobox; Display all entries when the down arrow is clicked. | Excel Programming |