Control Displays Number Instead of Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top