1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'Pour éviter la mise en boucle de l'événement
Set isect = Application.Intersect(Target, Range("B1"))
If Not isect Is Nothing Then
If InStr(1, Target, ":") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "?") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "#") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "'") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "\") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "*") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, ">") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "<") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "/") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
If InStr(1, Target, "|") Then MsgBox "Please don't use any of the caracters below:" & Chr(13) & Chr(10) & ": ? # ' \ / * < > |"
End If
Application.EnableEvents = True
End Sub |
Partager