A
Axel
Am trying to sort a list that contains a big amount of dates, with help
of two textboxes on a userform.
This don't work, but it shows the correct values in the custom dialog
from the dropdown box
Private Sub CommandButton1_Click()
Sheet1.Select
Dim FirstDate As Date
Dim LastDate As Date
FirstDate = TextBox1.Text
LastDate = TextBox2.Text
Selection.AutoFilter Field:=3, Criteria1:=">" & Format(FirstDate,
"mm/dd/yyyy"), _
Operator:=xlAnd _
, Criteria2:="<" & Format(LastDate, "mm/dd/yyyy")
Unload UserForm1
Grateful for any help
*** Sent via Developersdex http://www.developersdex.com ***
of two textboxes on a userform.
This don't work, but it shows the correct values in the custom dialog
from the dropdown box
Private Sub CommandButton1_Click()
Sheet1.Select
Dim FirstDate As Date
Dim LastDate As Date
FirstDate = TextBox1.Text
LastDate = TextBox2.Text
Selection.AutoFilter Field:=3, Criteria1:=">" & Format(FirstDate,
"mm/dd/yyyy"), _
Operator:=xlAnd _
, Criteria2:="<" & Format(LastDate, "mm/dd/yyyy")
Unload UserForm1
Grateful for any help
*** Sent via Developersdex http://www.developersdex.com ***