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
| Private Sub UserForm_Initialize()
'Les données à aficher dans les combobox sont contenues
'dans les colonnes A à D.
'Colonne A ---> cbox1
'Colonne B ---> cbox2
'Colonne C ---> cbox3
'Colonne D ---> cbox4
Dim m As Byte
Dim j As Integer, i As Integer, x As Integer
Dim Temp As String
'boucle pour remplir les combobox
For m = 1 To 4
x = Cells(65536, m).End(xlUp).Row
'Remplissage combobox
Me.Controls("cbox" & m).List() = _
Range(Cells(1, m), Cells(x, m)).Value
'Tri croissant dans les ComboBox
With Me.Controls("cbox" & m)
For i = 0 To .ListCount - 1
For j = 0 To .ListCount - 1
If .List(i) < .List(j) Then
Temp = .List(i)
.List(i) = .List(j)
.List(j) = Temp
End If
Next j
Next i
End With
Next m
End Sub |