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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Check if a string is part of an array (containing wildcards...)

02-02-2018, 10:56 AM

jodecaesteker jodecaesteker is offline

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

Office 2016

Novice

Join Date: Jan 2018

Posts: 6

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 PM.