Dropdown List - Change Display

**ewainscott** · 05-24-2007, 10:05 PM

Hello all -
I have set up a dropdown list and am wondering if there is a way to set the list to display a different value. For example, if the list shows Apple, Orange, Banana I would want the cell to show A, O, or B when a value is selected. Is this possible?
Thanks in advance!

**Paul** · 05-25-2007, 12:11 AM

Well, the solution most likely depends on what kind of dropdown list you're using.

If you're using a drop-down ("combobox") from the Controls Toolbox, you can code a Change event that will set any cell's value to whatever you want. For example:

Private Sub ComboBox1_Change()
    Range("C5").Value = Left(ComboBox1.Value, 1)
End Sub

If you are using a data validation drop-down list, you could use a Worksheet_Change event to do something similar, although you couldn't have the validation drop-down list and result in the same cell.