rapitorres
New Member
- Joined
- Oct 5, 2017
- Messages
- 39
- Office Version
- 2010
- Platform
- Windows
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
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