I have a combobox on a userform that has a Row Source of 3 columns and about
200 rows. I can get everything to work but the combobox will only display
the entry from the first column of the source. I would like it to display
the second column.

I have tried changing the Bound Column to 2. In fact, I have changed it to
0, 1, 2, and 3 and the combobox always displays column 1 information.

I can get it to work by shifting the columns around in my source data, but I
would like to avoid that if at all possible.

I am running Excel 2002.

Does anyone have any suggestions?

Thanks.

You need to set the TextColumn property to 2

Set the ColumnCount = 2 and ColumnWidths = 0

That will display two columns in the combo, but make the first column zero
points wide, giving the appearance that there is only one column in the
list.

Use BoundColumn to change which column is selected...Combobox1.Value and a
BoundColumn = 2 returns the item from the 2nd column of the selected row.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Martin" <(E-Mail Removed)> wrote in message
news:0A3F3F99-ABB6-4EBA-8D5D-(E-Mail Removed)...
>I have a combobox on a userform that has a Row Source of 3 columns and
>about
> 200 rows. I can get everything to work but the combobox will only display
> the entry from the first column of the source. I would like it to display
> the second column.
>
> I have tried changing the Bound Column to 2. In fact, I have changed it
> to
> 0, 1, 2, and 3 and the combobox always displays column 1 information.
>
> I can get it to work by shifting the columns around in my source data, but
> I
> would like to avoid that if at all possible.
>
> I am running Excel 2002.
>
> Does anyone have any suggestions?
>
> Thanks.
>

That worked. Thanks.


"Smallweed" wrote:

>
> You need to set the TextColumn property to 2