Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F2" And Target.Count = 1 Then
Application.EnableEvents = False
Target.Offset(0, 1) = Empty
n = Application.CountIf([Lapurdi_CP], Target)
Select Case n
Case 1
Target.Offset(0, 1) = [Lapurdi_CP].Find(Target, LookAt:=xlWhole).Offset(0, 1)
Target.Offset(0, 2) = [Lapurdi_CP].Find(Target, LookAt:=xlWhole).Offset(0, 2)
Case Is > 1
Target.Offset(0, 1).Select
SendKeys "%{down}"
End Select
Application.EnableEvents = True
End If
If Target.Address = "$G2" And Target.Count = 1 Then
Target.Offset(0, 1) = [Lapurdi_Villes].Find(Target, LookAt:=xlWhole).Offset(0, 1)
End If
End Sub