Private Sub UserForm_Initialize()
Dim combo
combo = Array(CBx2, CBx3, CBx4, CBx5, CBx6) 'met les combobox ici
With Worksheets("Liste item")
derlgn = .Cells(.Rows.Count, 5).End(xlUp).Row
Tablo = .Range(.Cells(2, 5), .Cells(derlgn, 5)).Value
End With
For i = 0 To UBound(combo)
combo(i).List = Tablo
Next
End Sub