Two Column Combobox with two linked cells

[lmckenzie55]

HELP PLEASE! I am new and will try to pose my problem simply.

I have an Active X ComboBox that properly displays two columns in the list with column A
selection in cell E13. I need Column B to display/link in cell P13.

Example:
Apple 1
Pear 2
Peach 3

I can't get the number (column B) to display in cell P13. The fruit (column A) is in E13 as needed.

Many Thanks

[6StringJazzer]

Welcome to the Forum!

You can only link the value from one column of a multi-column combobox to a cell. You can use the BoundColumn property to indicate which column's value is linked, but still only one value.

The way to do this is in code. Change "ComboBox1" to the name of your actual combobox, and change "MySheet" to the actual name of the worksheet. This code goes into the module for the entity containing the combobox (worksheet or userform):

Please Login or Register  to view this content.