searching for customer in a list

[wahib]

i have a list of customers. i want to search this list as i type in a cell

 

[khandelwal]

This is not possible in Excel. You are expecting a search bar which is a different game altogether.

 

[Logit]

.
This macro goes in a regular module :

Sub FilterClear()
Dim sh As Shape
Application.ScreenUpdating = False


With ActiveSheet
On Error Resume Next


    ActiveSheet.ListObjects("Searchtable").Range.AutoFilter


    ActiveSheet.ListObjects("Searchtable").Range.AutoFilter
ActiveSheet.TextBox1.text = ""
.Range("A5").Select
End With
    Application.ScreenUpdating = True
End Sub

This goes in the Sheet level module :

Private Sub TextBox1_Change()
Application.ScreenUpdating = True
 ActiveSheet.ListObjects("SearchTable").Range.AutoFilter Field:=11, _
        Criteria1:="1", Operator:=xlFilterValues
        Application.ScreenUpdating = True
End Sub

Here is a link to download the workbook : https://www.amazon.com/clouddrive/share/CY5EOug7637S33BOSGQbr6Izf3SHBF9cAzWBIMReoAL

You can edit the column headers to suit your needs. Note the comments in yellow.