Private Sub userform_initialize()
ComboBox1.List = Feuil1.Range("a2:d" & Feuil1.Cells(Rows.Count, 1).End(3).Row).Value
ComboBox2.List = Feuil2.Range("b1:b" & Feuil2.Cells(Rows.Count, 2).End(3).Row).Value
End Sub
Private Sub CommandButton1_Click()
If ComboBox1.ListIndex > -1 And ComboBox2.ListIndex > -1 Then
Feuil1.Cells(ComboBox1.ListIndex + 2, 2) = ComboBox2.Value
Feuil1.Cells(ComboBox1.ListIndex + 2, 3) = TextBox1.Value
Feuil1.Cells(ComboBox1.ListIndex + 2, 4) = TextBox2.Value
Else
MsgBox "combos .... non renseignées"
End If
End Sub