ComboBox with Dates
 

Use the Click event to reformat it:

Private Sub ComboBox1_Click()
ComboBox1.Value = Format(ComboBox1.Value, "mm/dd/yyyy")
End Sub


the other alternative is to load it with code (rather than using the
listfillrange property) and load it with string values representing the
dates.

--
Regards,
Tom Ogilvy

"mxinter" wrote in message
...
Hi Guys,

Im adding a Combobox into a spreadsheet that has a
dropdown with several dates. When the date is selected, it
automatically changes that date into a "text" format. For
instance the user selects 19-Sept and the window
shows "37883" after being selected instead of "19-
Sept".....can someone help me figure out....how to change
the format.....or a workaround.

Thx all the way down from Mexico,

mxinter