Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filer dates
Hi
When I use the below code for the autofilter conditions - txtStartDate and txtEndDate dosn't work. The dates are in the custom filter if I look after running the code and if I reactivate it after this everything i ok. Any help? txtStartDate and txtEndDate are input via text fields in a userform. Private Sub cmdOK_Click() if (Err) ... Else Selection.AutoFilter Field:=3, Criteria1:="=" & txtStartDate.Value, Operator:=xlAnd, Criteria2:="<=" & txtEndDate.Value End If ... End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filer dates
In which format are the dates in the worksheet cells ?
You can also use EasyFilter to filter on Dates Maybe you like it http://www.rondebruin.nl/easyfilter.htm "Steen" wrote in message ... Hi When I use the below code for the autofilter conditions - txtStartDate and txtEndDate dosn't work. The dates are in the custom filter if I look after running the code and if I reactivate it after this everything i ok. Any help? txtStartDate and txtEndDate are input via text fields in a userform. Private Sub cmdOK_Click() if (Err) ... Else Selection.AutoFilter Field:=3, Criteria1:="=" & txtStartDate.Value, Operator:=xlAnd, Criteria2:="<=" & txtEndDate.Value End If ... End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filer dates
Hi Ron
The cells in the worksheet are in the following format "yyyy.mm.dd" "Ron de Bruin" wrote: In which format are the dates in the worksheet cells ? You can also use EasyFilter to filter on Dates Maybe you like it http://www.rondebruin.nl/easyfilter.htm "Steen" wrote in message ... Hi When I use the below code for the autofilter conditions - txtStartDate and txtEndDate dosn't work. The dates are in the custom filter if I look after running the code and if I reactivate it after this everything i ok. Any help? txtStartDate and txtEndDate are input via text fields in a userform. Private Sub cmdOK_Click() if (Err) ... Else Selection.AutoFilter Field:=3, Criteria1:="=" & txtStartDate.Value, Operator:=xlAnd, Criteria2:="<=" & txtEndDate.Value End If ... End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Dates showing are not what I type | New Users to Excel | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |