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

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

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