Dim x, z As Long, i As Byte, y As Byte
Private Sub UserForm_Initialize()
For i = 2 To Sheets.Count
ComboBox2.AddItem Sheets(i).Name
Next i
'ect..
End Sub
Private Sub ComboBox2_Change()
x = ComboBox2
End Sub
Private Sub CommandButton2_Click()
If MsgBox("Confirmez-vous l'ajout des données?", vbYesNo, "confirmation") = vbYes Then
With Sheets(x)
z = .Cells(Rows.Count, 1).End(3)(2).Row
.Cells(z, 1) = ComboBox1.Value
For y = 1 To 16: .Cells(z, y + 1) = Me("TextBox" & y).Value: Next y
End With
End If
'ect..
End Sub