Excel 2007 : Combo or list box?

[mlsira]

I'm wondering if anyone can help.

I want to create a list box, or a combo box, however, my dillema is that my table has a multiple columns. I want to be able to see one of the columns from my table, and once the choice is made, I want a corresponding value from the other column to appear. How do I specify the column to be in the list box, and how to program it to show the value in the other column instead.
Is there a way?

[NBVC]

Maybe a sample worksheet attached along with examples of inputs and desired outcomes would help us visualize your dilemma.

[Richard Buttrey]

,

If I understand you correctly you just want to see a specific set of values from one of the columns in a range that is used by the .RowSource property of the combobox.

In which case you need to use the BoundColumn property of the list/combobox. If you want to see the 3rd column of your table, then set the BoundColumn to 3, and use the ColumnWidths property to hide the other columns. i.e. in the ColumnWidths property enter 0;0;25;0;0... etc for as many columns as there are in your table.

Remember that you can reset the Bound Column in code which is useful when you want to see different values from your table in the same ComboBox. It saves duplicating ComboBoxes.

HTH