1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| Private Sub tbxnom_Change()
Dim recherche As Range
Set recherche = Cells.Find(what:="recherche", after:=ActiveCell, LookIn:=xlFormulas, MatchCase:=False, searchformat:=False)
On Error Resume Next
tbxnom.Text = recherche.Offset(0, 1)
tbxprenom.Text = recherche.Offset(0, 2)
tbxsociete.Text = recherche.Offset(0, 3)
tbxtitre.Text = recheche.Offset(0, 4)
tbxemail.Text = recherche.Offset(0, 5)
tbxtelstandard.Text = recherche.Offset(0, 6)
tbxteldirect.Text = recherche.Offset(0, 7)
tbxfax.Text = recherche.Offset(0, 8)
tbxportable.Text = recherche.Offset(0, 9)
tbxportable2.Text = recherche.Offset(0, 10)
On Error GoTo 0
End Sub |
Partager