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

NoSparks · #1 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

jodecaesteker · #2 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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I compare a string in a cell to another string?	Amitti	Word VBA	2	04-10-2017 07:35 PM
Is there a way to delete the beginning part of an array so it doesn't overflow?	omahadivision	Excel Programming	4	01-15-2014 11:22 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Spell check checking only part of document	Adeyo	Word	1	02-24-2013 10:49 PM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM