Tri d'un tableau par la méthode "a Bulle"
Publié: 22 Fév 2008 à 11:54- Code : Tout sélectionner
Sub SortBubble(vrTable As Variant)
'Tri à bulle par ordre croissant
'Déclaration Variables
Dim nbUBound As Long
Dim nbLbound As Long
Dim i As Long
Dim J As Long
Dim vrValue As Variant
On Error Goto ErreurHandle
nbLbound = Lbound(vrTable)
nbUBound = Ubound(vrTable)
If nbUBound = nbLbound Then
'si 1 seule donnée pas de traitement
Exit Sub
Elseif nbUBound = (nbLbound+1) Then
'si uniquement 2 données
If vrTable(nbLbound) > vrTable(nbUBound) Then
vrValue = vrTable(nbUBound)
vrTable(nbUBound) = vrTable(nbLbound)
vrTable(nbLbound) = vrValue
vrValue = Null
End If
Exit Sub
End If
'Tri du tableau
For i=nbLbound To nbUBound-1
J = i
While (J>=i)
If vrTable(J+1) < vrTable(J) Then
vrValue = vrTable(J)
vrTable(J) = vrTable(J+1)
vrTable(J+1) = vrValue
End If
J = J-1
Wend
Next
vrValue = Null
Exit Sub
ErreurHandle:
Msgbox "("+Cstr(Getthreadinfo (1))+" Call by "+Cstr(Getthreadinfo(10))+")"+Chr(10)+"Erreur " + Str(Err) + " : "+Chr(10) + Cstr(Error)+". "+Chr(10)+"Ligne N° "+Cstr(Erl),16," ERREUR !"
Exit Sub
End Sub