Display Search results in ListBox with more than 10 Column ( 17 Column ) in excel VBA ||

ListBox in Excel is a powerful tools that enhances your skill in excel VBA. Today in this tutorial I will show you how to populate listbox based on TextBox keywords relating to a combobox which contains the value that you want to search and with a TextBox where you have to type as keywords.
and when you click on search button then it will show the search result in ListBox.

So you need to use rowsource method to load more than 10 Column in ListBox.

I used here for 17 Column.
if you need this file for your practice then massage me.

If You want to See VBA Code then view my blog

[agusp]

Listbox with Rowsource is All In One❤❤

[mohamedmoussaoui]

Excellent work, Thank you so much, Sir.

[bestonlinegk]

I will say "Excellent work".

[azimullahfaizy]

Excelent this is what i am looking for

[markanthonydizon]

Hi, I the code is working on my end. Thank you so much! However, when I pull out the form using a button from another sheet or using a button from the spreadsheet the combo box is missing its item, it is just leaving a blank option. Can you help me with this, please?

[vikashjee]

you should make videos in your voice so that it is clearly understandable and the channel will grow and people will get help from you.

[ledahbernardi]

I´m looking for a way to transfer data from listbox1 to listbox2, with dblclik, but both listboxes, have more than 10 columns. Do you have any video teaching something like that? Tks

[oreliocabezas]

hey nice work and thanks for helping me great job
thx
orelio

[EurysSantos]

Hi great video.

I'm creating a formular in which I have included a listbox and I want the headers to be shown but when I activate the option the headers are in blank. What should I do to make them appear?

[josephkimote]

👍 good things here. I need some more help: I have created a data entry userform with which I search for records using criteria search. However, when I search by any non text column such as number and date column it is not able to search. How can I modify the code to search text, number, date and even a combination of any data type? Any idea kindly help

[LoveYouHR]

good video sir... I have a userform containing combobox for item name, text boxes for item code, hsn, uom, qty, rate, discount1 and discount2 and labels of calculation like cgst, sgst, igst, taxable, and gross total. in totality, around 14 column. now the trouble is to populate all these data in listbox, as listbox is allowing only 10 cloumn. can u please help me... thanks in adv.

[akashrajpurohit]

My excel sheet table has some blank cells but in listbox it is showing zero instead of blank.how do i make it blank in listbox as well?

[jamesnkk]

Could you do a video where you can select the row and update the column

[KunaiForce]

sort of confusing with not defining what is the database sheet containing and what the searchdata sheet was containing

[pasongsinkhamchan]

This is amazing!. However, i have a problem my listbox does not filter date and other numeric criteria. For example I can only filter "Product code" but not "Week Number" even if it is numeric criteria. I have tried with multiple IF but it works only with one criteria. I have to put Elseif to be able to search Week number but then I still can not search for Date. When I change Elseif to Date, I can not search for Week number.

[Ramzyar]

It says Run-Time error '438'
Object doesn't support this property or method

[rogaranjah]

i need to watching u make a code in a worksheet database & searchdata. can u help me?

[rezabellana]

Does it work without the SearchData worksheet? I followed your procedure but it doesnt show in my listbox when i select the category and type the word in textbox. There's no error. Hope you can explain to me or help. This code need for my project.

[abdulsafwan]

Bro is that possible to paste the value in same sheet1 after filter

[joyzuniga]

I would like to request this file, I am getting an error at some point regarding record source if condition part.