Private Sub UserForm_Initialize()
'Alimente le ComboBox avec la liste stockée précédemment
Dim L As Long
With Sheets('Param')
L = .Range('A65536').End(xlUp).Row
If L = 1 And .Cells(1, 1) = '' Then Exit Sub
ComboBox1.List() = .Range(.Cells(1, 1), .Cells(L, 2)).Value '(merci Hervé!)
End With
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
With Sheets('Param')
'Recopie la liste dans la feuille 'Param' pour stockage
.Cells.Delete
.Range(.Cells(1, 1), .Cells(ComboBox1.ListCount, 1)) = ComboBox1.List()
End With
End Sub