Private Sub Worksheet_Change(ByVal Target As Range)
forme = create_pattern("###@@@###")
'MsgBox Target.Value Like forme
If not Target.Value Like forme then
'...
' ton code en fonction de false ici
'...
end if
End Sub
Private Function create_pattern(chaine)
create_pattern = Replace(Replace(chaine, "#", "[0-9]"), "@", "[A-Z|a-z]")
End Function