UserForm DTPicker code help

[Big Lar]

Sheet1 is data (values)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Sheet1 ColumnA is “Date” (format = mm/dd/yy)<o></o>
<o> </o>
UserForm2 uses two DTPicker controls to select a range of dates<o></o>
<o> </o>
I need help with the code to filter Sheet1 ColumnA based on UserForm2 selected range.

Or...is there a better solution?

 

[Domenic]

Assuming that Row 1 contains the column headers, try...

[font=Verdana][color=darkblue]Private[/color] [color=darkblue]Sub[/color] CommandButton1_Click()
    [color=darkblue]With[/color] Worksheets("Sheet1").UsedRange
        .AutoFilter field:=1, Criteria1:=">=" & Me.DTPicker1.Value, Operator:=xlAnd, Criteria2:="<=" & Me.DTPicker2.Value
    [color=darkblue]End[/color] [color=darkblue]With[/color]
[color=darkblue]End[/color] [color=darkblue]Sub[/color]
[/font]

Change the control names, accordingly.

 

[Big Lar]

Domenic,

"GENIUS!"

Thanks

 

[Domenic]

You're very welcome! Thanks for the feedback!