Private Sub UserForm_Initialize()
' trié
For i = 1 To Range("nom").Count
j = 0
Do While Range("nom")(i) > Me.ComboBox1.List(j) And j < Me.ComboBox1.ListCount - 1
j = j + 1
Loop
Me.ComboBox1.AddItem Range("nom")(i), _
IIf(Range("nom")(i) > Me.ComboBox1.List(Me.ComboBox1.ListCount - 1), j + 1, j)
Next i
End Sub