Textbook value search & populating sheet with selected rows

hello guys, I am in a bind here at work. I'm not very good at using VBA macros and have been assigned a project that deals with searching through various spreadsheets using userform that has textboxes and checkboxes. What I am trying to do is type a value in textbox1, for example, and it searches the sheet for that value in column 1 and only populates the sheet with rows that have the value I typed in the textbox1. If that value doesn't exist or is wrong, i want it to say no match found. Same goes for the next textbook, which will actually be looking through a different column within the spreadsheet but once the textbook value matches the ones on the spreadsheet, i want it to populate it with those rows that have that value. I have the command buttons down (search, cancel, etc), the part i am stumped on is the textbox. The code I have is as follows below for the first textbox, but it does not work fully. Also, how would I continue the code with the second texbox search function without it interfering with the first?

Please Login or Register  to view this content.

Sounds to me like you would be better off using AutoFilter. Submit your workbook for further review.

userform.png

The reason I didn't want to use autofilter is because I wanted it to be easy for someone else to just pull up that userform and select different types of searches without having to click around so much. This file isn't being made for my conveince though. Anyway, I played around with the code and took a slightly different approach. Please let me know what you think of it because it's still not fully working.

Please Login or Register  to view this content.

Autofilter can be performed within code so the steps will be the same you just will not have to do all the loops.

I can't see the picture you uploaded.

The code you supplied is inefficient and erranous. Submit a copy of your workbook.