Combo Box Selection Format

  • Thread starter Thread starter Ashley
  • Start date Start date
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
 
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
 

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

Combo Box Help 3
Combo Box Formatting 4
Graph linked with combo boxes 2
Combo Box Showing Date Selections 2
Combo box result text not number 2
Combo Box Display 5
combo box formatting 1
how do I load combo box from Excel columns? 1

Back
Top