User Form to Search multiple Criteria to return multiple Results

I took a different approach than your post requested. I included a listbox instead of multiple combo boxes. Click on the SHOW FORM button to start. You can select multiple options. The output is on Sheet 2.

Let me know if it helps.