Yodelayheewho
Member
Hello Forum!
I have two search challenges. See files attached for more detail and visuals.
I have a listbox labeled 3b on the userform that shows 8 columns (my data table has 113 total columns). These 8 columns contain the most critical data that are searched the most. Each of the column header titles are listed in the dropdown combo box labeled 1
1. To find a record, you make a selection from the dropdown
2. Type the search criteria in the textbox labeled 2
The search somewhat works. The match(s) float to the top of the listbox 3b, but non-matches are still visible. Fix 1: I would like ONLY matches to show in the listbox 3b.
My second challenge: I would like the search history to appear in listbox 3a and make these clickable, which would results would appear in listbox 3b.
For example, here are examples of possible full text and partial text searches:
1. Shop Order
2. ASO (partial text search)
1. Shop Order
2. MSO-14141 (full text search)
1. Transfer Order
2. MSO-1122 (full text search)
1. Customer Name
2. STU (partial text search)
Based on these searches, here is what would appear in listbox 3a.
ASO
MSO-14141
MSO-1122
STU
Thank you in advance for your consideration!
I have two search challenges. See files attached for more detail and visuals.
I have a listbox labeled 3b on the userform that shows 8 columns (my data table has 113 total columns). These 8 columns contain the most critical data that are searched the most. Each of the column header titles are listed in the dropdown combo box labeled 1
1. To find a record, you make a selection from the dropdown
2. Type the search criteria in the textbox labeled 2
The search somewhat works. The match(s) float to the top of the listbox 3b, but non-matches are still visible. Fix 1: I would like ONLY matches to show in the listbox 3b.
My second challenge: I would like the search history to appear in listbox 3a and make these clickable, which would results would appear in listbox 3b.
For example, here are examples of possible full text and partial text searches:
1. Shop Order
2. ASO (partial text search)
1. Shop Order
2. MSO-14141 (full text search)
1. Transfer Order
2. MSO-1122 (full text search)
1. Customer Name
2. STU (partial text search)
Based on these searches, here is what would appear in listbox 3a.
ASO
MSO-14141
MSO-1122
STU
Thank you in advance for your consideration!
