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.
Once this has been done for each ComboBox I have then recorded a separate macro for an Advance Search
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!