Private Sub UserForm_Initialize()
TextBox1 = "CL" & Application.Max(Feuil1.ListObjects(1).DataBodyRange.Columns(1)) + 1
End Sub
Private Sub CommandButton1_Click() ' AJOUTER
If Société = "" Then Société.SetFocus: Exit Sub
With Feuil1.ListObjects(1).DataBodyRange
If IsNumeric(Application.Match(Société, .Columns(2), 0)) Then
Société.SetFocus
Société.SelStart = 0
Société.SelLength = Len(Société)
MsgBox "Cette société existe déjà..."
Exit Sub
End If
With .Rows(.Rows.Count + 1)
Application.EnableEvents = False 'désactive les évènements
.Cells(1) = Replace(TextBox1, "CL", "") 'TextBox1 doit être verrouillée
.Cells(1, 2) = Société: Société = ""
.Cells(1, 3) = Nom: Nom = ""
.Cells(1, 4) = Prenom: Prenom = ""
.Cells(1, 5) = Fonction: Fonction = ""
.Cells(1, 6) = Adresse: Adresse = ""
.Cells(1, 7) = CP: CP = ""
.Cells(1, 8) = VILLE: VILLE = ""
.Cells(1, 9) = TelFixe: TelFixe = ""
.Cells(1, 10) = TelPort: TelPort = ""
.Cells(1, 11) = Mail: Mail = ""
.Cells(1, 12) = MSN: MSN = ""
Application.EnableEvents = True 'réactive les évènements
End With
End With
Société.SetFocus
UserForm_Initialize
End Sub