View Single Post
 
Old 07-09-2018, 07:04 PM
andxie andxie is offline Windows 7 64bit Office 2013
Novice
 
Join Date: May 2018
Posts: 15
andxie is on a distinguished road
Default Search through multiple sheets with multiple textboxes

I have a project wherein the user only knows the characteristics of a product and it has to show the products applicable to it. There are different sheets in the excel and they don't have the same headers.

I have multiple textboxes and a search button, then the results will be shown in a listbox. (see image)

is it possible to search even with one textbox? Also, when one textbox has been searched, when another textbox has been populated the possible results will decrease.

Hope someone could help me on this. I just have no clue how to do it
Attached Images
File Type: png Capture.PNG (40.1 KB, 13 views)
Attached Files
File Type: xlsm Book1.xlsm (40.2 KB, 9 views)
Reply With Quote