Private Sub CommandButton1_Click()
Dim critInf&, critSup&
With Worksheets("Home").Range("a10").CurrentRegion
.Sort Key1:=Range("j10"), order1:=xlDescending, Header:=xlYes
On Error Resume Next
critInf = Replace(TextBox1, ".", Application.DecimalSeparator)
critInf = CLng(Replace(critInf, ",", Application.DecimalSeparator))
critSup = Replace(TextBox2, ".", Application.DecimalSeparator)
critSup = CLng(Replace(critSup, ",", Application.DecimalSeparator))
If Not Err Then
TextBox1 = critInf: TextBox2 = critSup
.AutoFilter Field:=10, Criteria1:=">=" & IIf(critInf < critSup, critInf, critSup), _
Operator:=xlAnd, Criteria2:="<=" & IIf(critInf < critSup, critSup, critInf)
End If
Application.Goto ActiveSheet.Range("a1"), True
End With
CommandButton1.ForeColor = RGB(0, 0, 0)
End Sub
Private Sub TextBox1_Change()
CommandButton1.ForeColor = RGB(255, 0, 0)
End Sub
Private Sub TextBox2_Change()
CommandButton1.ForeColor = RGB(255, 0, 0)
End Sub