Check if a string is part of an array (containing wildcards...)

[jodecaesteker]

Hi all,



I'm new here and also very new to vba.

I want the user of an Excel worksheet to enter a string and I want to check whether that strings has a certain pattern.

The allowed patterns are:

##.
##.##.
##.##.L
##.##.##.
##.##.##.L
##.##.##.##.
##.##.##.##.L

# is any digit (0-9), L is any letter and the points are just that: points.
If the pattern of the string isn't one of the allowed patterns, a msgbox with an error message should appear and the macro should quit.

Is there a way to do this? (The patterns with the letters in them are not necessary, but it would be nice to include them.)

I have two choices for the string to be entered: the string might be entered by an inputbox, but I may also work with a userform. I know how to do that. I just need the check for the pattern...

Thanks in advance!
Jo D.