Need help with a search userform (SOLVED)

[codeformat]

Hi everyone,

I am new to the forum and am looking for some help. I have a userform that has 3 comboboxes that I am trying to use as the search criteria and a listview where I would like the results to be displayed. I am coming up short on how to do this and am looking for some help. I need the 3 comboboxes to all be true and have a value in order for the results to be accurate as there should be multiple results. I have attached the file I am working on and any help would be greatly appreciated.

Thanks!

[codeformat]

Any help at all would be more help then you know. I am not even sure if what I am trying to do is possible.

Thanks!

[mucbeanz]

set a variable for each text box or entry point

find last row



inside loop

if statement

if true do what

end



an example of something put together for a sheet i was working on mind you in their case all cases where the criteria is true its going to copy that line and put it into a new book. This form was used for downtime data base trend finding

Please Login or Register  to view this content.

[codeformat]

Thanks for the help I will try it out and see how it works.

[mucbeanz]

that code is an example only you'll need to change the locations and functions and variables to suit your sheet . hope it helps, or your able to make it work

[codeformat]

I tryed to make the code you posted work but I guess its a little outside what I am able to understand. can you dumb it down for me....lol

Thanks again for the help.