Dim col As String
Dim cellule As Range
Dim LigDep As Integer
col = "A"
Nomfeuille1 = "Param"
LigDep = 2
'
With ComboBox1
.Clear
.ColumnCount = 3
.ColumnWidths = "60;0;0"
'.Style = fmStyleDropDownList '
For Each cellule In Sheets(Nomfeuille1).Range(col & "2:" & col & Sheets(Nomfeuille1).Range(col & Sheets(Nomfeuille1).Rows.Count).End(xlUp).Row)
.AddItem cellule.Value
.List(.ListCount - 1, 2) = col
.List(.ListCount - 1, .ColumnCount - 1) = cellule.Row
Next cellule
col = "B"
For Each cellule In Sheets(Nomfeuille1).Range(col & LigDep & ":" & col & Sheets(Nomfeuille1).Range(col & Columns(1).Cells.Count).End(xlUp).Row)
.AddItem cellule.Value
.List(.ListCount - 1, 2) = col
.List(.ListCount - 1, .ColumnCount - 1) = cellule.Row
Next cellule
End With