Search through multiple sheets with multiple textboxes

andxie · #1 07-09-2018, 07:04 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format Multiple Textboxes Based On the Contents of One Text Box	dmcgettigan	Word VBA	1	02-27-2017 08:50 PM
search multiple sheets and create list from found rows	trevorc	Excel Programming	1	01-05-2017 06:24 PM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
copy second row from multiple sheets	Brian Reilly	Excel Programming	1	03-30-2015 01:21 PM
UserForm Search with multiple TextBoxes	johndough	Excel Programming	0	05-10-2014 12:11 PM