VBA - Filter/Un-filter column using Checkbox

[Spaztic]

Hi! I'm looking for vba code for the following.

I want to have a Check Box where the following occurs:
Checked: Filters entire column C looking for 'X'
Unchecked: Removes filter in column C

Is this something that can be done? Appreciate any help in advance!

 

[kevin9999]

Please try the following. Put the code in a standard module. Then right-click the check box - select Assign Macro and assign this macro to the check box.

Option Explicit
Sub Filter_If_Checked()
    Dim cx As Excel.CheckBox
    Set cx = ActiveSheet.CheckBoxes(Application.Caller)
    If cx.Value = xlOn Then
        Range("C:C").AutoFilter 1, "X", , , 0
    Else
        ActiveSheet.AutoFilterMode = False
    End If
End Sub