UserForm autofilter method

[AndyEd]

In the attached example I have a UserForm which selects records (rows) from sheet (Tracker). The record displayed is based on a combobox selection.

I would also like to filter the tracker sheet by file type (e.g. Open, Closed, Pending) and only display any relevant records. Would the best way be via a series of command buttons, radio buttons, or combobox?

Please see the attached for reference.

Test - Copy.xlsm

Thank you

 

[davesexcel]

If you do use a combobox, here is the code you can use, this example I named it cbo_FileType
In the UserForm_Initialize, populate the combobox

    With Me.cbo_FileType
        .AddItem "Open"
        .AddItem "Closed"
        .AddItem "Pending"
    End With

Then when you make a selection in the combobox, the comboboxChange event will kick in.

Private Sub cbo_FileType_Change()
    Dim sh As Worksheet
    Set sh = Sheets("Tracker")
    With sh
        .Range("A2").AutoFilter field:=4, Criteria1:=Me.cbo_FileType
    End With
    
End Sub

 

[AndyEd]

Hi Dave

Works a treat on the spreadsheet. I have however noticed that although the spreadsheet is filtered, when I then scroll though the records via the UserForm, using the Select Person combobox, all the records are still visible, not just the filtered selection.

Also, how would you factor in the removal of the filter to view all the records? as part of the selection process?

Thank you