Private Sub CommandButton1_Click()
Dim DestC As Range
Dim Dest As Range
Set DestC = Sheets("competences PA").Range("XFD1").End(xlToLeft)
DestC.Offset(0, 1) = ComboBox1
DestC.Offset(1, 1) = TextBox1
Set Dest = Sheets("Listes").Range("A65000").End(xlUp)
Dest.Offset(1, 0) = TextBox1
Dest.Offset(1, 1) = ComboBox1
Dest.Offset(1, 2) = TextBox3
End Sub