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 28 29 30 31 32 33
| Sub TestVariableTableau()
Dim LeTableau(1 To 3, 1 To 2) As Date
Dim a As Long, b As Long, i As Long
Dim str1 As String, str2 As String, str3 As String, str4 As String, resultat As String
'Remplissage de la première colonne
LeTableau(1, 1) = "31/01/2011"
LeTableau(2, 1) = "01/01/2011"
LeTableau(3, 1) = "10/01/2011"
'Remplissage de la seconde colonne
LeTableau(1, 2) = "10:00"
LeTableau(2, 2) = "16:00"
LeTableau(3, 2) = "11:30"
'Exécution du tri et mise à jour du tableau
For a = 1 To UBound(LeTableau, 1)
For b = a To UBound(LeTableau, 1)
If CDate(Format(LeTableau(b, 1), "dd mm yyyy")) < CDate(Format(LeTableau(a, 1), "dd mm yyyy")) Then
str1 = LeTableau(a, 1)
str2 = LeTableau(b, 1)
str3 = LeTableau(a, 2)
str4 = LeTableau(b, 2)
LeTableau(a, 1) = str2
LeTableau(b, 1) = str1
LeTableau(a, 2) = str4
LeTableau(b, 2) = str3
End If
Next b
Next a
'Ittération sur le nouveau tableau trié
For i = 1 To UBound(LeTableau, 1)
resultat = resultat & LeTableau(i, 1) & " à " & Format(LeTableau(i, 2), "hh:mm") & vbCr
Next i
MsgBox resultat
End Sub |
Partager