Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2018, 07:04 PM
andxie andxie is offline Search through multiple sheets with multiple textboxes Windows 7 64bit Search through multiple sheets with multiple textboxes Office 2013
Novice
Search through multiple sheets with multiple textboxes
 
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, 7 views)
Attached Files
File Type: xlsm Book1.xlsm (40.2 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search through multiple sheets with multiple textboxes Format Multiple Textboxes Based On the Contents of One Text Box dmcgettigan Word VBA 1 02-27-2017 08:50 PM
Search through multiple sheets with multiple textboxes 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


All times are GMT -7. The time now is 07:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft