auto filter with search

[Will]

If I drop down the auto filter on any column, I
choose "contains" and type the word "first", this will
give me only the rows with that word appearing in that
column. But is there a way to have another user just type
the key word in another cell and the filter will do the
same? I'm trying to keep the user from clicking the drop
down,choose custom,select contains,and then enter the key
word. Thanks............Will

 

[Don Guillett]

Yes, you could have a worksheet_change event that read the input cell and
fired the code to set the autofilter criteria for you. Then, you could have
a button macro that undid the autofilter. An example

With Range("A5:g" & lr)
..AutoFilter
..AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
end with