User Form to search multiple columns

I would recommend you keep the search clean, add another search textbox to your form called Tire Size. Set a TextBox_change event for both so if you type in one box, it clears the other.

Then when you click FIND, have it run a different macro based on which of the two search boxes is filled out.

Did you create this form?

First, open up the form in the VBEditor and add the second Text Box and label below the first (label Tire Size).

Then double-click the new Text Box and it will pop open the TextBox3_Change window.
Put in code like this:

Please Login or Register  to view this content.

This instructs that ANYTIME a change occurs in textbox3, change the value of textbox1 to nothing.

Now, back on the form, doubleclick the Textbox1 and do the same thing in reverse:

Please Login or Register  to view this content.

From there, add an IF/THEN to the beginning of your FIND button macro to see which textbox has a value.

Please Login or Register  to view this content.

This example could be adapted for whay you want.It displays the data in a listbox which can then be filtered.

FilterForm.zip


I can't really see why you need to use VBA, AutoFiltering the sheet should be good enough.