Search Function userform

[MRsec]

Good Day,
I am trying to write a code for a search button which searches a listbox based a specific input set in a textbox. The values searched are number or words, and the listbox contains values from a single column. The code i found below(ctto) but i don't understand why it only works for the first column of my list box.
SearchButton: A Button which upon clicking is supposed to initiate the search
SearchBox: The textbox which will contain the search value
AvailableNumberList: The listbox which contains the data
About 20 Columns in Total but I just want to search from Column A to G

Please Login or Register  to view this content.

Screenshot 2021-10-10 174549.png

[bakerman2]

can you attach a sample workbook?

Look at the yellow banner on top of the page on how to do that.

[MRsec]

Please find attached.I removed the code in the Search Command Button.

[bakerman2]

How about this?

Please Login or Register  to view this content.

[MRsec]

It works Mr.Bakerman but how do i make it not case sensitive when i input a value in search box either in lower or upper case.Seems for now it only works if is similar case to the current data.

[MRsec]

and if i have a certain data that has similar value from the search column but different value on the rest of columns in the table,how do i make the search loop like a "find next"?

[bakerman2]

Case insensitive.

Please Login or Register  to view this content.

[MRsec]

it is working mr baker,i removed the cbButton and did a SearchBox Change instead.But as you can see if i do have a similar value in columns that is in my searchbox it will look up for the first line that has similar value and it won't move to a second row that has similar word.i attached the file with search function with your code on it.