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

jodecaesteker · 02-02-2018, 10:56 AM

Quote:

Originally Posted by NoSparks

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

Great, thanks for completing the solution!