Hello All,
I'm new to VBA so bare with me. I am trying to setup a userform that will allow the user to enter data and search my "Data" sheet and output the resulting rows into the "Results" sheet. The user form will have a combination of check boxes and txt boxes with one search button at the bottom. I want it to be able to search each criteria and narrow down the results if found, if nothing is entered in the box I just want it to skip over it and move on to the next search field.
What is the best way to approach this, there are so many different ways I've seen people do it. Will the .find command work for that many criteria? Will a VB loop work better?
I have already created the user form UserData. I have also added a Search button on the "Results" sheet to start the macro. I want the first 4 check boxes to correspond to column D starting at row 12. I need the check boxes, if checked to search for a string with the same label beside it.
If somone can just help me out getting started, I know i can fill in the rest. I just don't know how to setup a multi search criteria and filter the results and output them to another sheet.
Thanks,
Brian
I'm new to VBA so bare with me. I am trying to setup a userform that will allow the user to enter data and search my "Data" sheet and output the resulting rows into the "Results" sheet. The user form will have a combination of check boxes and txt boxes with one search button at the bottom. I want it to be able to search each criteria and narrow down the results if found, if nothing is entered in the box I just want it to skip over it and move on to the next search field.
What is the best way to approach this, there are so many different ways I've seen people do it. Will the .find command work for that many criteria? Will a VB loop work better?
I have already created the user form UserData. I have also added a Search button on the "Results" sheet to start the macro. I want the first 4 check boxes to correspond to column D starting at row 12. I need the check boxes, if checked to search for a string with the same label beside it.
If somone can just help me out getting started, I know i can fill in the rest. I just don't know how to setup a multi search criteria and filter the results and output them to another sheet.
Thanks,
Brian