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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 1
ComboBox displays duplicates - please help 2
populate combobox from worksheet in different workbook 3
combobox change fires on workbook close when textcol <>1 or -1 2
Add Item To ActiveX ComboBox 17
UserForm ComboBox Date Format 1
Can Listfillrange be used with a listbox or combobox on a form? 2
How to Load Combo Box with Named Range 4

Back
Top