1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| Private Sub CommandButton2_Click()
'tri des dates
Range("E18:E31").Select
Selection.NumberFormat = "General"
DoEvents
Cells(18, "E").CurrentRegion.Select
Selection.Sort Key1:=Range("E18"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
DoEvents
Columns("E:E").Select
Selection.NumberFormat = "dd/mm/yyyy"
End Sub
Private Sub CommandButton3_Click()
'tri des pays
Cells(18, "E").CurrentRegion.Select
Selection.Sort Key1:=Range("F18"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub |
Partager