problem in search result in listbox

Hi everyone
I have a problem with this code
The code works well and after writing in the text box or selecting the combo box
It shows the results in a listbox
But this is my problem
After showing the results in the list box, the scroll list box goes to the end
I want it to show only the number it finds in the listbox
I show my problem better in the photo

Please Login or Register  to view this content.

tanks bro
the workbook uplaoded

Here a simple example. I think you can rewrite this to your situation. This is the only code you need. See file

Please Login or Register  to view this content.

thanks my dear friend
Your file is good
But there are a few problems
My data has nine columns and 2000 rows
which becomes extremely slow when searching
another point
If the first column is empty between the lines, its continuation will not be displayed in the list box
If possible, please look at my code so that the results of the list box are shown only in the number found and when I scroll to the end of the list box, there are no empty spaces.

Ok listen, delete all of your code behind the userform. Then only add this code below. Still superfast on 20000 rows on my side.
Note that every row in the listbox is one string, instead of individual records.

Test on your posted sample file

Please Login or Register  to view this content.

Try modify this line

Please Login or Register  to view this content.

Originally Posted by daboho

Try modify this line

Please Login or Register  to view this content.

It's really amazing
thanks my dear friend

Originally Posted by kar2rost

It's really amazing
thanks my dear friend

Welcome, good luck

Originally Posted by JEC.

#6 will be faster though

Thank you too
But implementing that code for 9 columns and 2000 lines was really time consuming
In any case, thank you for your time, my good friend