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.

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

--
Jay


"(E-Mail Removed)" wrote:

> 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.
>
>