Autofilter Criteria From a TextBox

[farah.adila]

I would like my prog retrieves from a worksheet based on what users
input in a textbox.

look_for = Workbooks("CONTRACT").Sheets("Advanced Find").Cells(9,
3).Value
Range("C3").AutoFilter Field:=3, Criteria1:=look_for, Operator:=xlAnd


Instead of having the exact look_for, I want the program to retrieve
any words contain from the look_for. Tried to use
Criteria1:="*look_for*" but the program will certainly filter for
words look_for.

 

[Guest]

Hi Farah -

Convert the look_for variable into a valid criterion for the Autofilter's
Criteria1 argument: look_for = "=*" & look_for & "*".

look_for = Workbooks("CONTRACT").Sheets("Advanced Find").Cells(9,
3).Value
look_for = "=*" & look_for & "*".
Range("C3").AutoFilter Field:=3, Criteria1:=look_for, Operator:=xlAnd