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.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

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

--
Regards,
Tom Ogilvy

"Chaplain Doug" wrote in message
...
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.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org