Private Sub CommandButton1_Click()
On Error Resume Next
If TextBox6 = "" Then
'Message à l'utilisateur
MsgBox "Saisie d'un numéro de devis obligatoire.", vbInformation
'sortie de la procédure
Exit Sub
End If
If TextBox6 <> "" Then
With Sheets("Liste")
nb_contact = 0
For i = 2 To 5000
If IsEmpty(Cells(i, 1)) Then
nb_contact = i - 2
Exit For
End If
Next
.Cells(nb_contact + 2, 1) = TextBox6
.Cells(nb_contact + 2, 2) = ComboBox1.Value
.Cells(nb_contact + 2, 3) = TextBox14
.Cells(nb_contact + 2, 4) = ComboBox2
.Cells(nb_contact + 2, 5) = ComboBox3
.Cells(nb_contact + 2, 6) = ComboBox4
.Cells(nb_contact + 2, 7) = TextBox19
.Cells(nb_contact + 2, 8) = TextBox18
.Cells(nb_contact + 2, 9) = TextBox2
.Cells(nb_contact + 2, 10) = TextBox3
.Cells(nb_contact + 2, 11) = TextBox4
.Cells(nb_contact + 2, 12) = TextBox5
.Cells(nb_contact + 2, 13) = TextBox7
.Cells(nb_contact + 2, 14) = TextBox8
.Cells(nb_contact + 2, 15) = TextBox9
.Cells(nb_contact + 2, 16) = TextBox10 ' * 1 pour avoir la cellule au format numérique
.Cells(nb_contact + 2, 18) = TextBox11
.Cells(nb_contact + 2, 19) = TextBox12
.Cells(nb_contact + 2, 20) = TextBox13
.Cells(nb_contact + 2, 21) = TextBox15
' .Cells(nb_contact + 2, 17) = ComboBox5.Value
End If
TextBox1 = ""
TextBox2 = ""
TextBox3 = ""
TextBox4 = ""
TextBox5 = ""
TextBox6 = ""
TextBox7 = ""
TextBox8 = ""
TextBox9 = ""
TextBox10 = ""
TextBox11 = ""
TextBox12 = ""
TextBox13 = ""
TextBox14 = ""
TextBox15 = ""
TextBox16 = ""
TextBox17 = ""
TextBox18 = ""
End With
End Sub