Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$K$5" Then
Application.EnableEvents = False
If Not IsNumeric(Target) Or (UCase([i5]) = "AC" And (UCase([J5]) <> "NV") _
Or [i5] = "" And [J5] = "") Then
MsgBox "Saisie interdite ou erronée", , "Information"
Target = ""
End If
Application.EnableEvents = True
End If
End Sub