Thread: Filter column using criteria from a userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Filter column using criteria from a userform
Use an ampersand to join the operator and variable:

Selection.AutoFilter Field:=51, Criteria1:="=" & Variable1, _
Operator:=xlAnd, Criteria2:="<=" & Variable2


Eileen wrote:
I would like to filter a column based on criteria entered
into a userform. I've got this code so far using actual
dates:
Selection.AutoFilter Field:=51, Criteria1:="=01/06/2003",
Operator:= _
xlAnd, Criteria2:="<=30/10/2003"

BUT, I want to substitute the dates for variables that
come from a date picker on the userform, ie =variablename
I've tried:
Criteria1:= = variablename
Criteria1:= "=" variablename
Criteria1:= "=variablename" - this picks up the words,
not the variable

But none of them work - what syntax do I use?

Please help.
Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote