VBA search box

Hi,

I have two rows with 10.000 lines each, i wonder if there is possible to make an easy search box using VBA, searching values in row A and then get the Value of row B in the search box?
vba.PNG

Thank you in advance

Henrik

Hi,

Thank you for the response, it is a lot of similar numbers so normal filtering is not working so well. What i was wondering is making a Active X controlled search button, but not sure how the VBA code would be.

Hi sintek,

That is awesome, exactly what i wanted The numbers go down to row 10555, how do i extend the VBA code to search all of them?

Henrik- If you look at his code (5th line "lRow = ..."), you'll see he finds the last row in column A, so you should be able to see all the values.

You are right, had my numbers in the wrong format. It works perfectly now, thank you so much sintek