Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UserForm DTPicker.Value as Autofilter Crieteria
Hi all,
How Can I use DTPicker1.Value and DTPicket2.Value as my Autofilter crieria1 and Crieteri2? Thanks Sulu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UserForm DTPicker.Value as Autofilter Crieteria
Sub SetFilter()
With Userform1 Worksheets("Sheet1").Range("A1").AutoFilter _ Field:=1, _ Criteria1:="=" & .DtPicker1.Value, _ Operator:=xlAnd, _ Criteria2:="<=" & .DtPicker2.Value End With End Sub you might have to do clng(.DtPicker1.Value) clng(.DtPicker2.Value) -- Regards, Tom Ogilvy Sulu wrote in message ... Hi all, How Can I use DTPicker1.Value and DTPicket2.Value as my Autofilter crieria1 and Crieteri2? Thanks Sulu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averageif with 3 crieteria | Excel Worksheet Functions | |||
Printing from Userform with AutoFilter | Excel Discussion (Misc queries) | |||
Counting cell depending on certain crieteria | Excel Discussion (Misc queries) | |||
How do you use DTpicker in a Userfrom | Excel Discussion (Misc queries) | |||
Use DTPicker value as autofilter Crieteria | Excel Programming |