I'm trying to do a search with more than 3 parameters.
I.E.
| CONCEPT | COUNTRY | YEAR | MONTH | BOOK 1ST | BOOK LAST | LOCATION | # BOX |
| BILLS | US | 2020 | JANUARY | 001 | 013 | 111643 | 5743 |
| BILLS | US | 2020 | JANUARY | 014 | 024 | 111643 | 5758 |
| BILLS | US | 2020 | JANUARY | 025 | 034 | 111643 | 5759 |
| BILLS | US | 2020 | JANUARY | 035 | 039 | 111643 | 5760 |
| BILLS | US | 2020 | JANUARY | 040 | 044 | 111643 | 5761 |
| PAYMENTS | MEXICO | 2021 | MARCH | 001 | 008 | 111643 | 5783 |
| PAYMENTS | MEXICO | 2021 | MARCH | 009 | 017 | 111643 | 5767 |
| PAYMENTS | MEXICO | 2021 | MARCH | 018 | 021 | 111643 | 5768 |
| PAYMENTS | MEXICO | 2021 | MARCH | 022 | 029 | 111653 | 5769 |
| PAYMENTS | MEXICO | 2021 | MARCH | 030 | 033 | 111653 | 5770 |
| PAYMENTS | MEXICO | 2021 | MARCH | 034 | 042 | 111653 | 5771 |
| PAYMENTS | MEXICO | 2021 | MARCH | 043 | 048 | 111653 | 5772 |
| PAYMENTS | MEXICO | 2021 | MARCH | 049 | 061 | 111653 | 5773 |
| PAYMENTS | MEXICO | 2021 | MARCH | 062 | 075 | 111653 | 5774 |
| PAYMENTS | MEXICO | 2021 | MARCH | 076 | 088 | 111653 | 5775 |
| PAYMENTS | MEXICO | 2021 | MARCH | 089 | 100 | 111653 | 5776 |
| PAYMENTS | MEXICO | 2021 | MARCH | 101 | 112 | 111653 | 5777 |
| PAYMENTS | MEXICO | 2021 | MARCH | 113 | 121 | 111653 | 5778 |
In the list sometimes I need to search for a single box, and I need to search with 3 o more parameters.
In this moment I had the Idea of one parameter I don't know if it's possible search with concept, country, year and/or month.
The VBA I get is from a topic from this website from Philip Treacy, https://www.myonlinetraininghub.com/display-all-matches-from-search-in-userform-listbox?unapproved=87977&moderation-hash=7d77561db7af44e6f7687bea1f8ea8b2#comment-87977
Thanks in advance.
Hi Gael,
The easiest way is to add helper columns in the data sheet: for example, you can create a column for 3 parameters search, combining 3 columns into this column.
This way, you don't have to modify the existing code.
