Userform to search and display data only

Hello,

I'd like to make a userform with a textbox, command button and listbox. Enter text into the textbox and click search, then the list box displays 23 columns of data from a worksheet. This is going to be used to query shipments. So the textbox will lookup the customer name in column B, then after searching the listbox will display all rows and columns of data pertaining to that customer (so columns B through X and however many rows that customer is listed).

Example

Search for QQQ in the textbox, and the listbox would show something like:
QQQ 9/17/16 FedEx $345 etc etc
QQQ 10/20/16 FedEx $345 etc etc
QQQ 11/4/16 FedEx $345 etc etc
QQQ 1/1/17 FedEx $345 etc etc
QQQ 5/7/17 FedEx $345 etc etc
QQQ 8/15/17 FedEx $345 etc etc

I found some code listed on another site that I'm trying to modify but I have no idea if this is the correct way to do this. Plus, I can't figure it out anyway, and I'm also not sure what properties I need to set for the listbox (if any) to make it work. Here's the code:

Please Login or Register  to view this content.

If anyone knows what I'm trying to do either with this code or using another method, please let me know.

Thanks!

That code is something I found online. I can't get it to work even for an example. I have shipping data in rows from column B through X, each column pertaining to a set criteria like freight company, cost, delivery date, etc. I would like to have a userform I can use to search the shipments. Open the userform, type my search into a textbox which references column B, then click another command button to start the search and have a listbox show all results pertaining to my search.

customer	date	carrier	cost
company A	1/1/17	fedex	$10
company A	5/6/17	ups	$50
company B	6/18/17	usps	$25
company B	9/12/17	r&l	$200

Based on that example, if I search for company A, the listbox in the userform would should all rows of data for company A.

In requesting I make a sample file, it helped me to get the code working somewhat, lol, so thanks! I still need to figure out the offset and listcount stuff, confused how that works. What would I do for this code to show the correct data in the listbox if I search for company "A"?

Please Login or Register  to view this content.

Once I figure this out I can modify it all to fit my actual spreadsheet.

Thanks for the help!

Please Login or Register  to view this content.

@ bakerman2

That worked on the example sheet but didn't work if the command button was on a different sheet than the one with data. I'm sure it can be modified easily to work but I didn't try that.

@ jindon

Thanks, that works perfectly!




Thanks again for the help everyone!