Private Sub CommandButton_Valider_Click()
Dim no_ligne As Integer, civilite As String
For Each bouton_civilités In Frame_Civilités.Controls
If bouton_civilités.Value Then
Civilités = bouton_civilités.Caption
End If
Next
With Sheets("Fichier Client")
no_ligne = .Range("A" & .Rows.Count).End(xlUp).Row + 1
.Cells(no_ligne, 1) = Me.ComboBox_Groupe1.Value
.Cells(no_ligne, 2) = ComboBox_Groupe2.Value
.Cells(no_ligne, 3) = civilite
.Cells(no_ligne, 4) = TextBox_Prénom.Value
.Cells(no_ligne, 5) = TextBox_Nom.Value
.Cells(no_ligne, 6) = ComboBox_Note.Value
.Cells(no_ligne, 7) = TextBox_Entreprise.Value
.Cells(no_ligne, 8) = TextBox_Fonction.Value
.Cells(no_ligne, 9) = TextBox_Portable.Value
.Cells(no_ligne, 10) = TextBox_Fixe.Value
.Cells(no_ligne, 11) = TextBox_Email.Value
.Cells(no_ligne, 12) = TextBox_Adresse.Value
.Cells(no_ligne, 13) = TextBox_Codepostal.Value
.Cells(no_ligne, 14) = TextBox_Ville.Value
End With
ComboBox_Groupe1.ListIndex = -1
ComboBox_Groupe2.Value = -1
TextBox_Prénom.Value = ""
TextBox_Nom.Value = ""
ComboBox_Note = -1
TextBox_Entreprise.Value = ""
TextBox_Fonction.Value = ""
TextBox_Portable.Value = ""
TextBox_Fixe.Value = ""
TextBox_Email.Value = ""
TextBox_Adresse.Value = ""
TextBox_Codepostal.Value = ""
TextBox_Ville.Value = ""
End Sub