Microsoft Office Forums - View Single Post - Check if a string is part of an array (containing wildcards...)

NoSparks · 02-01-2018, 07:03 AM

Quote:

The patterns with the letters in them are not necessary, but it would be nice to include them.

you could Case Select based on length of str and include the letter

Code:

Select Case Len(str)
    Case 3: If str Like "##[.]" Then ok = True
    Case 4: If str Like "##[.][A-Z, a-z]" Then ok = True
    ' etc
End Select