I made a search box for my worksheet but it seems to only recognize symbols and numbers, but I need it to include letters. How can I do this?
Private Sub Textbox2_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("Antibodies").Range.AutoFilter Field:=4, Criteria1:="*" & [D2] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
Private Sub Textbox2_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("Antibodies").Range.AutoFilter Field:=4, Criteria1:="*" & [D2] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub