Hello and Thank You For Any Help
I have created a Excel Ms Query and have created a User form to limit
between Values of DTPicker1 And DTPicker2. I thought this would work.

Any Suggestions Please Help

Sub SetFilter()
With UserForm1
Worksheets("Sheet1").Range("A5").AutoFilter _
Field:=1, _
Criteria1:="=" & .DTPicker1.Value, _
Operator:=xlAnd, _
Criteria2:="<=" & .DTPicker2.Value
End With
End Sub

Mike
Check this site for further explanantion

http://www.dailydoseofexcel.com/arch...-data-queries/

Hope this helps
MarMo


"Mike" wrote in message
...
Hello and Thank You For Any Help
I have created a Excel Ms Query and have created a User form to limit
between Values of DTPicker1 And DTPicker2. I thought this would work.

Any Suggestions Please Help

Sub SetFilter()
With UserForm1
Worksheets("Sheet1").Range("A5").AutoFilter _
Field:=1, _
Criteria1:="=" & .DTPicker1.Value, _
Operator:=xlAnd, _
Criteria2:="<=" & .DTPicker2.Value
End With
End Sub