I have the following programming attempting to use the variable CBOX as my
Criteria1 in an autofilter. I get a syntax error on the autofilter line when
i run it. The line works fine if I use "=" as opposed to the "<" which i
want. I am attempting to filter away the variable in CBOX.

========================
Private Sub CheckBox3_Click()
Dim cbox As String
Let cbox = CheckBox3.Caption

If CheckBox3 = False Then
Selection.AutoFilter Field:=40, Criteria1:<cbox

Else
Selection.AutoFilter Field:=40
End If

End Sub

========================
thanks,
dr chuck