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/