Autofilter Using Form Value

Aaron.Brett · Nov 27th 2004

Hi

I am trying to use a value entered on a form by the user to use as part of an auto-filter process. The code (which isn't working!) is below:

Selection.AutoFilter Field:=13, Criteria1:="=*&TxtDescr.Value*", Operator:=xlAnd"

The code should say 'field contains' the TxtDescr.Value.

Any ideas (please!)

Thanks

Aaron

Barrie Davidson · Nov 28th 2004

Re: Autofilter Using Form Value

Try this (not tested):

Code

Selection.AutoFilter Field:=13, Criteria1:="=*" & TxtDescr.Value & "*", Operator:=xlAnd"

Hope this helps out!

Participate now!