I have a userform with a combo box with a row source = Lookup!$A$2:$B$4
with bound column = 1 and column widths of 0;144pt

When I select an item, what gets displayed is the bound column, not th
second colum

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

I just tried this in xl2002 and it worked ok for me. All I could see were the
values from column B.

What version of excel are you running? Maybe that'll get better help.


jhloney wrote:

I have a userform with a combo box with a row source = Lookup!$A$2:$B$46
with bound column = 1 and column widths of 0;144pt

When I select an item, what gets displayed is the bound column, not the
second column

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson

The boundcolumn (which is 1 based) identifies the column that will be
assigned to the value of the combobox and/or the value to be displayed in
the controlsource.

The textcolumn identifies which column in the selected row that will be used
to display the value of the selection in the combobox.

Set textcolumn to 2.

However, if textcolumn is set to -1, then the first column that has a
non-zero width would be used - which in your case would be the second
column. But if it isn't working, use 2 to specify it explicitly

--
Regards,
Tom Ogilvy

jhloney wrote in message
...

I have a userform with a combo box with a row source = Lookup!$A$2:$B$46
with bound column = 1 and column widths of 0;144pt

When I select an item, what gets displayed is the bound column, not the
second column


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/