Private Sub ComboBox1_Change()
Me.ComboBox2.Clear
Me.ComboBox2.List = Sheets("feuil1").Range(Me.ComboBox1).Value
End Sub
Private Sub UserForm_initialize()
Dim DerLig As Long
Dim I As Byte
With Sheets("feuil1")
ComboBox1.List = .Range("B3:B" & .[B65000].End(xlUp).Row).Value
For I = 5 To .[IV2].End(xlToLeft).Column
DerLig = .Cells(65000, 5).End(xlUp).Row
.Range(.Cells(3, I), .Cells(DerLig, I)).Name = .Cells(2, I).Value
Next I
End With
End Sub
DerLig = .Cells(65000, 5).End(xlUp).Row
DerLig = .Cells(65000, I).End(xlUp).Row