Use TextBox as search in ListBox (string or number)

Hello,
I got this ListBox with Names and numbers, I would like to be able to use TextBox above as search through it, any part of text or number. I've found some online code but I haven't been able to modify it to my needs. Any help appreciated.
vaZ5gIU.jpg

Do you want to just find the first match, or do you want to find all matches?

Your screenshot looks like it might be a userform. In the future please attach your file, because this context is important. Here is a solution for a userform:

Please Login or Register  to view this content.

Your listbox MultiSelect property must be set to fmMultiSelectMulti.

This is different than what your first post says, which is that you want to search through the listbox. If you want to populate the list box based on a search of data in a worksheet you are going to have to provide all of the details about where the data is. The best thing is to attach your file with sample data (see yellow banner at the top of the page). You also need to describe how you want the search to work from the user's point of view. Do you want the listbox to be refreshed every time there is any change to the textbox? Or do you want to add a Search button so the user can populate the listbox when he has completed the textbox?

making a new file all over again would take too much time

Such is the cost of asking for free help.

You can modify the code I provided to loop through your worksheet range looking for matches, in the same way my code looks for matches in the listbox. Here is the idea:

Please Login or Register  to view this content.

For anyone wondering, I've managed to find the solution:

Please Login or Register  to view this content.