Filter Multiple Columns with same Criteria

[haymesan]

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