Combo Box Selection Format

A

Ashley

Hi,
I am adding a combo box to my spreadsheet which looks at a
range of dates I have in the first column of the
spreadsheet.
The drop down list is formatted correctly - as a date
similar to the format of cells in the first column.
However, once I make a selection from the combo box, it
shows the selection as the excel value of the date (38068
rather than 3/22/04).
How can I format the combo box to also show the selected
date in date form?
Thanks in advance for your help! I appreciate it!
- AShley
 
C

Cesar Zapata

One way, double click the comobobox .. it should take you the the VBE
then so something like the above.


Private Sub ComboBox1_Change()
ComboBox1.Text = Format(ComboBox1.Text, "mm/dd/yy")
End Sub


change the combobox name and formatting part according to your needs.


Bye,

Cesar Zapata
 
Top