I have a multi-column combobox on a userform. The combobox drop-down
has 3 columns - 1) category, 2) part number, 3) part description.

When an item is selected in the drop-down the combobox field shows the
part number (column 2). Another (locked) field is then populated with
the part description using code in the change event.

Is there a way that I can enable the combobox to allow type-ahead with
the 2nd column values? For example, if the user types "1" then the
combobox would show part number 1000, if they next type a "3" after
the "1" then the combobox shows part number "1300", etc. Type ahead
works fine on a single column combobox but I can get it to work with
the multi-column combobox.

Ideally I would also like the part description field to populate with
the related value as the user types 1, 12, 123 etc.