Need help with cross reference of parts from more than one source

I have modified the workbook to use a macro to get the unique ids and use the list to fill an activeX combobox for the search. The combobox will filter as you type in the id #. When the box changes the search is triggered automatically.