Hi: I M trying a 2 DTPicker Cohtrols on a user form to filter a sheet, but for some reason it filters for the date 1/0/1900, i did use DTPicker control already a few times an it works well, in fact on the same sheet i have got another user form with a DTPicker control on it and it works great, but for some reason, on this form it wont give me the desired value..
If OptionReceived = True Then With Sheet1.Range("A1").End(xlUp) .AutoFilter field:=1, Criteria1:=">=" & DTPicker1, _ Operator:=xlAnd, Criteria2:="<=" & DTPicker2 End With End If
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.