Hello everyone,
I'm a new to excel vba. I'm trying to do the search as you type and I would like to filter all columns in the table when I type a letter. Can you help me with this?
Private Sub TextBox1_Change()
ActiveSheet.ListObjects("Table1").Range.AutoFilter field:=1, Criteria1:=TextBox1.Text & "*", Operator:=xlFilterValues
End Sub
I'm a new to excel vba. I'm trying to do the search as you type and I would like to filter all columns in the table when I type a letter. Can you help me with this?
Private Sub TextBox1_Change()
ActiveSheet.ListObjects("Table1").Range.AutoFilter field:=1, Criteria1:=TextBox1.Text & "*", Operator:=xlFilterValues
End Sub