Filtering Search Box with 2 or more variables.

[DanPa]

I'm using a template from "The Spreadsheet Guru" that helps you filter data from a table according to what you type and what column you indicate the search to run.

The thing is that the code only lets you filter 1 variable and I would like to filter 2 or more variables having multiple options. Sometimes I get error 400, sometimes I get results (still not obeying the filter options) and sometimes I get blank results.

Not sure what I'm missing, I'm stating that the Macro needs to run all 3 text boxes to do the filter but it doesn't.

For last, I state that at the end of each search, the buttons should become False, but it only does the first one.

Apologies for many threads I'm opening, but I'm working (practicing) on multiple ones at the same time.

Regards,

[alansidman]

I have removed the txt boxes you were using for criteria and placed the criteria in Cells B1,D1 and E1 and then used the following code

Please Login or Register  to view this content.

To clear the criteria, I assigned the following code to that button

Please Login or Register  to view this content.

[sintek]

Hi DanPa

Another option making use of Alan's idea....
Option Buttons which allows choice of filter i.e. car only, Car & Color, Car&Color&Year...
Perhaps someone else can simplify...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[DanPa]

Hi again.

I apologize for replying so late, went to bed early. I will work with this two examples you kindly provide me and will come back with the results.

Thank you

[DanPa]

Ok, so I'm working with Alans' code, I can't get it to run as I want to but I'm also not getting any errors. Removing the TextBox was great idea, less mess in the workbook.

Now there is two things I think I'm messing that is not making this work.

I want to change the radio buttons for checking buttons. If checking button is = true, then the Macro includes that variable in the search, otherwise it does not. But I'm not sure how to change this one.

Sintek, your option is very good but I have trouble if I want a different combination of options to be included in the filter.

Please Login or Register  to view this content.

[sintek]

Try this...Rather unusual

Please Login or Register  to view this content.