Adding dynamic excel filter search box to existing exel tables?

[louai]

Hello all,

Please help me with this. I have tried many vba and tutorials on youtube but with no any luck. I wanna add dynamic excel filter search box to existing exel tables.

Can you please help with any tips?

 

[Kamolga]

Can you put a simple example of what you want to reach?

For example, let's say you have a table with titles in Line 2
A Car Brand
B Car model
C Car price

You want a list in A1 combining cars and model that would filter the table on selected model?

 

[louai]

Filter out as you type model.

So when i type the letter C the cars show up

 

[Kamolga]

Pretty easy. Make a Table (insert tab, table) and Name it (design tab, Table Name). I name mine TblSales.

Then yo got to devloper tab (you can make it appear from File/options/custom ribbon if yo don't have it already).

Go to insert and chose the ActiveX Textbox (the one with ab| ).

Draw one on yor table sheet. Right click and go to properties. In linked cell, chose an empty cell and typed its reference. I chose a1.

Right click yor textbox again and click view code

Private Sub TextBox1_Change()
[COLOR=#008000]'Replace the words TblSales and a1 with your own table name & linked cell address. You can also change the field number (2) to the column to filter[/COLOR]
ActiveSheet.ListObjects("TblSales").Range.AutoFilter Field:=2, Criteria1:="*" & [a1] & "*", Operator:=xlFilterValues
End Sub

.

You can click the little play in VBA after you click between private sub & end sub you jst pasted or get out of design mode in devloper tab. It works already.

 

[louai]

Wow that worked for me! amazin.

Please can you to this: how to apply this code to the whole sheet? so not only for 1 table but for all text on the whole sheet?