Combo box columns

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:-
=Offset(A3,A1,0)
And in C1:-
=Offset(B3,A1,0)

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!

Thank you - Tim Francis-Wright

Its works Happy New from Botswana