check box "when checked" filter this, if "not checked" reset filter

[rapitorres]

Hi I already done this by using Macro. it works but then the problem is even if uncheck its still filters. By clicking it again whether its check or not it will just filter

here is my macro code
Sub SFR_Click()
Worksheets("ORDER REPORT LAZADA").Range("A5").AutoFilter Field:=12, Criteria1:="SFR"
End Sub

now I'm trying to implement it in VBA
here's what I got

on checkbox1

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Worksheets("ORDER REPORT LAZADA").Range("A5").AutoFilter Field:=12, Criteria1:="SFR"
If CheckBox1.Value = False Then Range("LAZADA[[#Headers],[ORDER ID]]").Select.AutoFilter

End If
End Sub

And yup. not working
anyone

 

[KOKOSEK]

Can be done like this:

Private Sub CheckBox1_Click()
With ActiveSheet
    If CheckBox1.Value = True Then
        .ListObjects("LAZADA").Range.AutoFilter Field:=12, Criteria1:="SFR"
    Else
        .ListObjects("LAZADA").Range.AutoFilter Field:=12
    End If
End With
End Sub

 

[rapitorres]

I almost got it right. thankyou for saving me lots of clicking. works like a charm, Appreciated

 

[KOKOSEK]

Happy to help.