easy combo box question

  • Thread starter Thread starter jhloney
  • Start date Start date
J

jhloney

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
 
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.
 
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
 
Back
Top