[RESOLVED] Use Textbox.Value in AutoFilter Criteria

[Cristobal16]

OK, I have the following code generated by autofiltering on a list of names using a text filter "Contains" and then the typed text, "Juan":

'    ActiveSheet.Range("$A$2:$P$611").AutoFilter Field:=4, Criteria1:="=*Juan*" _
'        , Operator:=xlAnd

I would like a search button in my UserForm to activate this code when clicked. The difference is, in place of "Juan" I would like to have whatever the user types in TextBox14, which would be in the same UserForm as the search button. The following was my attempt at the search button's code:

Private Sub CommandButton26_Click()
    ActiveSheet.Range("$A$2:$P$611").AutoFilter Field:=4, Criteria1:="=" & UserForm1.TextBox14.Value & "*" _
        , Operator:=xlAnd
End Sub

When clicked, I get no errors, and it filters my data, but it doesn't work correctly; all of the rows get filtered out, which must mean that whatever my code's autofilter criteria resolves to, it's not in the column of names. Any ideas on how to write this criteria so that my textbox's value will get used in the filter?

[Cristobal16]

I figured it out, if anyone is interested:

Private Sub CommandButton26_Click()
    ActiveSheet.Range("$A$2:$P$611").AutoFilter Field:=4, Criteria1:="=" & "*" & UserForm1.TextBox14.Value & "*" _
        , Operator:=xlAnd
End Sub