VBA Userform to search data in a table filtering results based on all search criteria

Hi,

Im very new to VBA and userforms so I am struggling with the following

I have a userform that searches the data in my table however it only searches based on the last dropdown option that is selected. So in this case "Location". Id like to change it so that the results only show if they match all the selected criteria. (For example if I select a "Product / Service" and a "Location" the results only show if they match both not just the last one.

Thank You, (I have attached the workbook for reference)

Originally Posted by torachan

alternative method - primary search is done by comboboxes - secondary search done by choice from listbox.
the comboboxes only contain one of each item if multiples - however the choice places all in the listbox.
torachan.

Thank You, This is something I wanted to do so helps massively but what I meant originally is to have it so that I can filter the results by more than 1 of the comboboxes. So I can narrow down the results by first choosing a category then choosing 1 or more of the other comboboxes and the result that appear in the main list box have to match all of the choices in whichever combo boxes have been filled in.

But thank you, the change you have made is something I was going to look at once I had fixed my problem above

EDIT: I have managed to solve it, Thanks again.