View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron McCormick[_2_] Ron McCormick[_2_] is offline
external usenet poster
 
Posts: 21
Default Code to allow user to enter criteria for autofilter

I would like to write a procedure that would allow a user
to enter dates ie one greater than and the other less than
in a programmed autofilter procedure.

Essentially I would want the user to be able to insert
their own chosen dates in place of the dates that appear
in the undernoted code without them seeing the code.

Selection.AutoFilter Field:=3, Criteria1:="31/10/2002",
Operator:=xlAnd, Criteria2:="<=31/10/2003"

TIA
Ron