Private Sub btnModifier_Click()
Dim i As Integer
r = MsgBox("Voulez-vous confirmer la modification", vbYesNo, "Gestion fonctionnaires")
If r <> 6 Then Exit Sub
With Range("t_BDD").ListObject.DataBodyRange
For i = 1 To .Rows.Count
If .Item(i, 1) = Me.txtCode.Text Then
.Item(i, 2) = Me.cboCivilité.Text
.Item(i, 3) = Me.txtNom.Text
.Item(i, 4) = Me.txtPrénom.Text
.Item(i, 5) = Me.txtAdresse.Text
.Item(i, 6) = Me.txtCP.Text
.Item(i, 7) = Me.txtVille.Text
.Item(i, 8) = Me.txtTéléphone1.Text
.Item(i, 9) = Me.txtTéléphone2.Text
.Item(i, 10) = Me.txtMail.Text
Exit For 'on quitte
End If
Next i
End With
End Sub