I have a form with a multicolumn combobox (CBNames). it gets its list from
columns a, B, and C of a worksheet. (Number, FirstName, LastName) i have the
column count set at 3, and the column widths set appropriately. when a user
clicks the arrow to "Drop Down" the combobox, and he/she selects an item from
the list, what is shown in the box is just the number, the first column. is
there a way to get it to display all 3 items for that row in the combobox
after it is selected? TIA