Activex ComboBox affecting Advanced Filter Macro

HI,

I have a database of suppliers and their skill set on Tab one ( "full comb List") and then on Tab 2 ( "search engine" ) I have created 5 Excel activex combobox Drop Down list with Search Suggestions. so that the user can select a certain criteria and the advanced search will then show suppliers that meet these criteria.

I have then created the following piece of VBA code for each box to make them dynamic.

Please Login or Register  to view this content.

Once this has been done for each ComboBox I have then recorded a separate macro for an Advance Search

Please Login or Register  to view this content.

The issue is when I then run the macro by selecting a criteria from the dropdown list the macro Either gets stuck on the "full comb List" tab or doesn't display the required data on the "search engine" it just displays the column headers and not the data.

If I perform the advance search without the macro or with out the activex combobox then it works perfectly.

Any ideas, im relatively new to coding etc and have been searching for a solution for a couple of days now?

Thanks in Advance!

Could you attach your sample workbook (without sensitive data).
If you're having trouble using the attachment, please read this info:
http://www.excelforum.com/showthread.php?t=1128657