Private Sub Buttonok_Click()
'--- Positionnement dans la base
[A65000].End(xlUp).Offset(1, 0).Select
'--- Transfert Formulaire dans BD
ActiveCell.Value = Application.Proper(Me.TextBox1)
ActiveCell.Offset(0, 5).Value = Me.TextBox1
ActiveCell.Offset(0, 6).Value = Me.TextBox2
ActiveCell.Offset(0, 7).Value = ComboBox1
ActiveCell.Offset(0, 8).Value = Me.TextBox4
ActiveCell.Offset(0, 9).Value = Me.TextBox5
ActiveCell.Offset(0, 10).Value = Me.TextBox7
ActiveCell.Offset(0, 11).Value = Me.TextBox8
ActiveCell.Offset(0, 12).Value = Me.TextBox9
ActiveCell.Offset(0, 13).Value = Me.TextBox10
ActiveCell.Offset(0, 14).Value = Me.TextBox11
ActiveCell.Offset(0, 15).Value = Me.ComboBox2
ActiveCell.Offset(0, 16).Value = Me.ComboBox3
ActiveCell.Offset(0, 17).Value = Me.TextBox18
ActiveCell.Offset(0, 18).Value = Me.TextBox6
ActiveCell.Offset(0, 19).Value = Me.TextBox12
ActiveCell.Offset(0, 20).Value = Me.TextBox13
ActiveCell.Offset(0, 21).Value = Me.TextBox14
ActiveCell.Offset(0, 22).Value = Me.TextBox15
ActiveCell.Offset(0, 23).Value = Me.TextBox16
Unload Me
End Sub