Userfrom to search multiple critera and have partial matches.

Hi,

In the attached excel form I have set up a userform to search my data which is set up perfectly except it does not narrow down the results by multiple criteria. I would like to change it so that the results that show match all the filled in criteria (which can be any combination of category, product, company and/or location). So if I fill all the fields in on my userform the search result has to match all of the inputs. Also with the "company" criteria it would be great if it could work with a partial match so maybe a search box would work better than a dropdown for this criteria.

Any help would be much appreciated as I'm very new to VBA and have little experience.

Thank You

what are the values in your code called UBDand and Dand? they have no declarations. plus, when searching in your form, the code breaks on Dand.Value. see images.

Apologies, they are redundant. The dropdowns used to be combined with option buttons and text boxes to create a more advanced search but I didn't need them for what I am trying to achieve. So the 3 you mention refer to option buttons that are no longer there. I should have deleted that part of the code apologies.

can you repair the code so it runs with no errors then?

If you are only searching on your database use the database content to populate the comboboxes.
In this manner you are only searching for items that exist - there is no need for separate listings.
The combos feed only those items relevant to the preceding search and only contain uniques not duplicates of entire listing.
Start from the left as each combo loads the next to the right - on dismissing the form it will transfer the selection to the second listing.
A hidden sheet keeps track of the filtered listbox.
torachan.

Ah That works thank you!