Populate ListBox based on Textbox Keywords || Display search results in listbox while typing..

#nsutradhar #display_Search_Result
There are many way to search words, numbers in excel. In this video we will learn the easiest way to find out search items by using excel vba. It will works like a software. Just input your text in TextBox, it will show the matched content in ListBox from worksheets. You can use this method in your workbook very easily.
If you want to learn about excel vba, goto my channel page see the videos.
a way to search data from worksheet .. Excel VBA
Create Ledger for your Party ( Account Ledger)

3. Fully Automatic Data entry userform-

GST Billing Software Series
How to create Address Book according to GST billing and Accounting

Check Management System in Excel VBa

Upcomming
GST Invoicing in Excel VBA like Tally

IF YOU NEED TO VIEW VBA CODE THEN CLICK THE BELOW LINK

if you want to remove duplicate items from listbox while typing then see

[arkdum]

I think you might have made the right video for my project.
Thanks

[nathanielcongreso]

This the what ive been looking for. Thank you so much.

[fahimmulla]

dynamic populating the list with text from textbox was awesome and I was able to do my work without issue. Thanks !

[junjiejay]

Thank you Nsutradhar. He help me a lot, he willing to help in short time. Support him !!

[ShahidulIslam-vbsk]

Yes, it's exactly like what you replied & What I want.That's populate Textboxes & at the same time a listbox based on textbox1 keywords. Thanking you in anticipation.

[eastgrammarschool]

Thanks dear you have solved my big problem.Thanks

[ShahidulIslam-vbsk]

Received your file.Thanks a lot & I've already subscribed your channel.

[aannasrulloh]

how with 2 textbox to filter (2 condition), so textbox1 to filter listbox and textbox2 to filter again the listbox? thanks

[rrvszlu]

I've solved a problem that I've been very curious about.
I'm subscribed to your video.
I'll study and watch other videos,
Thank you so much.

[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?

[tseringchomphel]

great lesson. However, I got an issue with my program. my excel data contain both alphabet and numeric in the same cell (eg. b230), whereas the search does not detect alphabet but it search according to number. Need help with this.

[carlosgaspar]

Hi, Very good, but how to do it if we want to use the same textbox to look for a data from another column than the first?
I would really like to know the solution for this case. thank you very much for your availability

[Fazwaans]

Hi, I really like your video, Specially the search function. Can you kindly add more function like ADD data...Delete Data...Update Data.... in this project...Thanks

[fiqah]

hi can you make a video like this, whenever the user double click the listbox it will open the pdf file (with the hyperlink from excel table to pdf file) - pdf file that is located at the mapped network (this pc). really appreciate your kind help

[TheTeknoman]

is there anyway you can add another row on the userform? because i have tried another column and add code on it seems to be locked only the current set up

[chhansambath]

Hi how to show header in the list box more than 20(mine54header)

[mariamxxxx]

This is the only video that worked (partially) for me. I have several issues, the search column that I want to search by is my 6th column (column F), can you guide me to how I can do this? also search results are duplicated or occurs 3-4 times as am typing. In general, i don't really understad what i, x and p is...

[oediarti]

Where to put Blue colour in header sir?

[mathmadeeasy]

I am Textiles engineer. I have to develop an AI where I can compare EPI, PPI, Greige width and gets Finished Width automatically. Please help what should I do...

[mannymany]

Hi Guru. Is there a fix to the duplicating values in the list box when typing the first character in the text box? Thank you so much for this tutorial. It is very helpful.