VBA code to show filtered results in a Listbox

Hello all, please see the attached file. Column A in the 2nd sheet has the master list (which will be updated to add more lines in the future). The remaining columns are storage boxes that contain various food plant seeds as shown.

What do I need help with? - In the drop down Combo Boxes in Parameters 1-5, I would like the five drop down Combo Boxes to populate the Seeds list column A in the 2nd sheet. When parameters are entered and the Show Storage Boxes button is pressed, I would like to see the relevant storage boxes show up in the list box as shown. In this example, only Storage Box 1, 3, 4, 7 and 8 contain a match for the seeds selected via the Parameter drop down Combo Boxes.

If you can please help to code the UserForm1 to try to achieve this task, it would be appreciated. Also, instead of having multiple 'Parameter' drop down Combo Boxes (five in this example) - if you can perhaps suggest a better option - maybe a multi-select combo box, where one can choose all their parameters (seeds) and then click the command button and have the List Box populate the data then that works too.

Note: the list box, which shows the results after the button is pressed, should always be empty by default and it should only populate with data when the button is clicked.

Thank you!

April 15 - 2025 image example of result.png

Here, try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

with USERFORM2 using multi-select listbox

Hello and thank you zbor. Your method works fine but when multiple parameters are selected, only the boxes with the common parameters are returned. What I would like to have returned in the list are all the boxes where those parameters are present as shown below. Also, if there is a storage box where 2 or more selected parameters are present in, then don't return them in the list as duplicates but only list the storage box once.

zbor - example.png

Thank you for this ByteMarks. This is quite another way to approach it. I got some debugging errors a few times but API approaches has created these errors in the past. I think it is a software thing. Thank you nonetheless!

Please Login or Register  to view this content.

Limited to selection of 8 seed types!

Version with headings ..

Please Login or Register  to view this content.