I can not get my data to filter when I am trying to set up a filter as you type kind of filter. I saw a video of the TeachExcell but in the video it was a range not a table. please Help.
Table Name: Append4
Tab:ALL
This is how far I have done it.
Private Sub TextBox1_Change()
Dim filterInput As Range
Dim Append4 As ListObject
Set MainSheet = Sheets("ALL")
Set Append4 = MainSheet.ListObjects("Append4")
Set filterInput = Range("C15")
MainSheet.AutoFilter Field:=3, Criteria1:="*" & filterInput & "*", VisibleDropDown:=Flase
End Sub