Hello, trying to improve my Excel knowledge and currently working on a project with text filters above all table fields. Letters work well but I can't get numbers to work.
First post but sure won't be my last, I'm finding it like playing an incredibly complex game.
Excel table
First post but sure won't be my last, I'm finding it like playing an incredibly complex game.
VBA Code:
Private Sub TextBox1_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("List").Range.AutoFilter Field:=1, Criteria1:="*" & [c1] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
Excel table