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.