Display Search Results in a ListBox - Excel VBA

In this video, we display search results in a listbox on a userform in Excel VBA.

In this scenario, the user is searching for a product. They enter a keyword and the search results are shown in a listbox. They then make a selection and it is added to the spreadsheet.

*** Online Excel Courses ***

Find more great free tutorials at;

Connect with us!

[sushilpugalia]

Thanks Computergaga!
It helped me a lot. I am new to customise excel workbook via VBA. It is easy to make many changes in code to suit my requirements as I know VB coding. Your logic to copy search results to new range, did the trick. I was attempting autofilter which was not giving me visual output I needed.
Once again I thank you.

[Sage-Thyme]

Excellent vid, just the right level of info and I was so pleased when you capitalised the 'p' because it was bugging me also.

[thetproject]

Thanks for the video very useful
If I could ask you, how did you use the vlookup function in the first minute of the video how do you type in the cell and you take the row from the other sheed.. Do you have a video about this ?

[YTXYZ]

Great Video.... this works great. Is there a way to select multiple products (ie. if you searched on Louisiana and it returned a list of 8 products containing Louisiana), how could I select 2 or more of the products without having to do a second or third search? Example: I'm searching on a golf course that has multiple tees (Men's Black, Blue, White, Red, and Ladies White and Red tees), and I wanted to return the details of Men's White and the Ladies Red tees. Is there a suggested way to pull both desired tees without having to go through the process of describing a second search?

[haroldfinch]

I have been looking for this type of solution for two
I implemented this inside a userform and all populated a google search like suggestions in combobox drop down....😀😀

[OzduSoleilDATA]

Louisiana Fiery Pepper Sauce. Well, ok!!! 🔥🔥🔥
Good work on this project!

[BillyLynn-et]

Very useful. Thank you. What do I need to do if I want same search user form, with same stock data and same product search, but for two form sheets, lets say sheet "form" and sheet "form1"?

[arsalanahmed]

nobody made such a search system in excel which is so effective like this one

[karen-ob]

Hi! thank you very much for this tutorial. What will be the instr code for a search on multiple columns and not just one?

[eivindsteinsb]

Thanks Computergaga!
One Question:
In this video you can only search matches in column B "Product name".
How can I make it search in both columns A "ID" and B at the same time?

[saidkurt]

Merhaba vermiş olduğunuz bilgiler için çok teşekkür ederim

[ulquiorra]

Thanks for this video.


I kindly need help here, if there are 3 worksheets available, how do you then search through these worksheets and display the result in the list-box?

[kennethfrandsen]

Great how-to! Thanks! I need a little help though. If I want to use this on another sheet and DON'T want the Worksheets("Stock Data").Activate to actually show, but stay in the sheet I work on. Then how do I do that? The cmdSearch_Click() should just run in the background.

[craigcostford]

This is superb, this has worked really well. I wonder, instead of adding the results of the listbox onto a spreadsheet could you select the search results you want then add them into another userform. For example one of the columns on the listbox results could be date, which when added would go into a userform - if so, I would love to know how to do that!!

[SyedMuzammilMahasanShahi]

Thanks for sharing thin interesting video.

[flavours]

sir do you have a simple inventory related to this video?

[pembelajarexcel]

Thank u for this very useful tutorial...

[MrTopdawg]

Curious, can you use any wild card search’s in the text search box?

[gavinflanigan]

So if I was doing something similar but copying the data to a userform I would replace row 10 with "Userform2.Textbox1.value = Worksheets("Product Search").cells(listboxrow, 1).value" ?

[genterprisesskn]

Hi Computergaga. In this video, you mentioned about worksheet construct, but you didn't show example because it was only three (3) columns. I have a work sheet with over 50 columns, therefore i would like you to please send me the "construct" method, so that i don't have to type so many data for my many columns worksheet. Thank you in advance.