Hi everyone,

I'm really stuck. I'm trying to create a tool whereby the user presses a button which brings up a userform and they can then filter by multiple criteria in that column. For example, by Tenure Type; they choose Retired Housing and Supported Housing and it filters to those two only.

At the moment I have this;

Private Sub OKButton_Click()

If CheckBox5.Value = True Then ActiveSheet.Range("$B$8:$I$320").AutoFilter Field:=6, Criteria5:= _
    "Retirement"
If CheckBox8.Value = True Then ActiveSheet.Range("$B$8:$I$320").AutoFilter Field:=6, Criteria8:= _
    "Supported Owned and Managed"
End Sub
Which kind of works except it filters by the first THEN the second - i.e. Supported Owned and Managed within Retirement. I need it to filter by the first AND the second so it shows all the results for both.

There are actually 9 Tenure Types for them to choose from so the number of variables is...well you do the math, it's huge. I'd like it if they could filter by up to 8 of the 9 if possible!

And before you ask, yes I know this is perfectly do-able via the normal filter drop-down menu but I've been told to make it "accessible for all levels of expertise" which in this case can mean people who don't know how to spell Excel let alone use it.

I've been struggling with this for hours so any help would be really appreciated!

Thanks,

Viv