MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ComboBox displaying number instead of date

Posted by Peter C on January 14, 2002 10:52 PM

My combox has dropdown list of dates (in a 15 January, 2002 format)but when selected the combobox displays the number, ie, 32678.

How do I change the combobox format to diplay the date as selected?

Thanks in advance.

Posted by Ivan F Moala on January 15, 2002 2:27 AM

This may help;

Private Sub ComboBox1_Change()
ComboBox1.Text = Format(ComboBox1.Text, "dd mmmm yyyy")
End Sub

Place in worksheet code module ie.
Rightclick sheet tab
Select view code
Paste code in



Posted by Peter C on January 15, 2002 3:19 AM

Thanks Ivan, Works Perfectly