Private Sub CommandButton1_Click()
Dim vDate As Date
Set f = Sheets("Feuil2")
vDate = CDate(Format(TextBox2, "mm/dd/yyyy"))
f.Range("K1:K2").Value = Application.Transpose(Array("DATE DE DEBUT", vDate))
Sheets("Agents").Range("Tableau1[#All]").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=f.Range("K1:K2"), _
CopyToRange:=f.Range("L1:AB1"), _
Unique:=False
Me.Hide
End Sub