Dim MSt As String Dim ArrS as Variant Dim blnNoIp as Boolean MSt = Clipboard.GetText On Error Resume Next If Len(MSt) > 7 And Len(MSt) < 17 Then If InStr(MSt,".") > 0 Then ArrS = Split(MSt,".") For V = 0 To 3If Val(ArrS(V)) < 1 And V 0 Then blnNoIp True If Val(ArrS(V)) > 255 Then blnNoIp = True Next V If Err.Number Then blnNoIp = True Else blnNoIp = True End If Else blnNoIp = True End If If blnNoIp = False Then MsgBox "C'est une IP"