Control Displays Number Instead of Date

[Guest]

Excel 2003. I put a combobox control on my sheet that has a ListFillRange
that points to a column with dates in it. However, when I select one of the
dates, the combobox displays a number (e.g., 2/28/2006 is displayed as
38748). How can I set the format for the combobox so that it displays the
date properly? Thanks for the help.

 

[Tom Ogilvy]

You can't. You would have to program the click event to format at

Private Sub Combobox1_Click()
Combobox1.Value = Format(Combobox1.Value,"mm/dd/yyyy")
End Sub