Format Display in ComboBox

[King]

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

 

[pfsardella]

Try browsing through the answers provided by this search.

http://www.google.com/groups?as_q=F...F-8&as_ugroup=*excel*&lr=lang_en&num=50&hl=en

HTH
Paul

 

[Tom Ogilvy]

Private Sub Combobox1_Click()

Combobox1.Value = Format(cDate(combobox1.Value),"m/d/yyyy")

End Sub