Salut,
En passan par un tableau VBA, modifies dans Ton module Thisworkbook:
Private Sub Workbook_Open()
'***********************************************************************************
'initialisation combobox regroupant tous les salariés de l'entreprise
Dim T
With Sheets("bilan_horaire")
T = Range(.[A2], .[A65536].End(xlUp)).Value
TriMulti T, 1, LBound(T), UBound(T)
For I = LBound(T) To UBound(T)
If (T(I, 1)) <> "" Then .ComboBox1.AddItem T(I, 1)
Next I
End With
'***********************************************************************************
End Sub
Sub TriMulti(Tablo, Col As Byte, Min&, Max&) 'ZOn
'Tri dichotomique
Dim I&, J&, K&, M, Chaine
I = Min
J = Max
M = Tablo((Min + Max) / 2, Col)
While (I <= J)
While (Tablo(I, Col) < M And I < Max)
I = I + 1
Wend
While (M < Tablo(J, Col) And J > Min)
J = J - 1
Wend
If (I <= J) Then
For K = LBound(Tablo, 2) To UBound(Tablo, 2)
Chaine = Tablo(I, K)
Tablo(I, K) = Tablo(J, K)
Tablo(J, K) = Chaine
Next K
I = I + 1
J = J - 1
End If
Wend
If (Min < J) Then TriMulti Tablo, Col, Min, J
If (I < Max) Then TriMulti Tablo, Col, I, Max
End Sub
A+++