rabarber
10-29-2008, 05:00 AM
Hello. Can anybody tell me, how can i textbox value put in the autofilter contain criteria.
Selection.AutoFilter Field:=1, Criteria1:="=*textbox1.valu(Do not work :( )*", Operator:=xlAnd
ActiveWindow.SmallScroll Down:=-12
i basically want to make form with textbox where i input only part of word what i want to find, so i need contain criteria.
thank you :)
Selection.AutoFilter Field:=1, Criteria1:="=*textbox1.valu(Do not work :( )*", Operator:=xlAnd
ActiveWindow.SmallScroll Down:=-12
i basically want to make form with textbox where i input only part of word what i want to find, so i need contain criteria.
thank you :)