Private Sub CommandButton2_Click()
'Sheets("TASKS").Range("$A$1:$Q$500").AutoFilter Field:=6, Criteria1:=">=11/06/2014", Operator:=xlAnd, Criteria2:="<=15/06/2014" ' recorded
Sheets("TASKS").Range("$A$1:$Q$500").AutoFilter Field:=6, Criteria1:=">=" & Me.TextBox1.Text, Operator:=xlAnd, Criteria2:="<=" & Me.TextBox2.Text ' adapted for using textbox dates entered on a form
Unload Me
End Sub
In column F I have a list of dates (dd/mm/yyyy).
I can manually filter dates ok, but want to set it to part of code to use automation for a report.

The code when run, finds nothing, where it should.
I tried using [CDate] also but also same result.