Combobox Row Source

M

Martin

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.
 
T

Tim Zych

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top