1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Private Sub Worksheet_Change(ByVal Target As Range)
Dim Kase As Range
If Not Application.Intersect(Target, Range("A2:A15")) Is Nothing Then
If Target.Count > 1 Then
For Each Kase In Target
Worksheet_Change Kase
Next Kase
Exit Sub
End If
If Not IsEmpty(Target.Value) Then 'on verifie que la cellule n'est pas vide de données
Target.Offset(0, 1).Formula = "=VLOOKUP(A2:A15,Feuil1!A1:B10,2,0)"
Else
Target.Offset(0, 1).ClearContents 'on efface la formule
End If
End If
End Sub |
Partager