Private Sub UserForm_Initialize()
'-----------No Reset
CheckBoxReset1.Caption = False
CheckBoxReset2.Caption = False
' restitution pour CheckBox
Dim Com, i%, y%, Ctrl As Control, cbval
lgn = ActiveCell.Row
Com = Split(", " & Feuil2.Range("B" & lgn), ", ")
For i = 1 To UBound(Com)
For Each Ctrl In Me.Controls
If TypeOf Ctrl Is MSForms.CheckBox Then
If Ctrl.Caption = Com(i) Then
Ctrl.Value = True: Exit For
End If
End If
Next Ctrl
Next i
'--------------'restitution pour ComboBox
lgn = ActiveCell.Row
cbval = Split(Feuil2.Range("M" & lgn), ",")
ComboBox1.Value = cbval(0)
ComboBox2.Value = cbval(1)
ComboBox3.Value = cbval(2)
ComboBox4.Value = cbval(3)
End Sub