MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo box columns

Posted by Gary Ford on January 03, 2001 10:11 PM

I have a combo box with 2 columns of information

I want the information in the 2 columns to be bound to 2 separate cells

Posted by Tim Francis-Wright on January 04, 2001 9:04 AM

The ActiveX combobox has a BoundColumn property,
which specifies the column that generates values
sent to the LinkedCell. If BoundColumn = 0,
then the ListIndex is sent, rather than the
values of a particular column.

Therefore, you can't have the LinkedCell property
work on 2 or more columns at once.

But, there's probably an easy way around this.
Let's assume that you have a matrix in cells A3:B10
with the following values:
radiohead, 100
tmbg, 90
bonzo_dog_band, 80
spike_jones, 85
napoleon_xiv, 88
dogzilla, 79
yes, 25
nkotb, 0

If you specify A3:B10 to be the ListFillRange,
0 to be the BoundColumn, and A1 to be the LinkedCell,
then you could Have a formula in B1:-
And in C1:-

Making a selection from the combobox will send
the ListIndex to A1; you can then use the figure
there to get the proper lookups from the
range in question.

Hope this helps!

Posted by Gary Ford on January 05, 2001 12:26 PM

Thank you - Tim Francis-Wright

Its works Happy New from Botswana