VBA- Contains any element

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way I can search a string to see if it contains any element of
another string (or array)? If so, can you give me an example so I can get
the syntax right.

I am trying to force entry of more than 5 characters, at least one of which
is from the 26-character alphabet, into a form text box.

Thanks.
 
Look at the InStr function in VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the maximum in an array of strings (Excel VBA) 6
Cannot write the contents of an Object to file 7
InputBox entries & advice 16
Extracting the Nth element from a String 1
Transpose Function not Working with Long Array Elements 4
ReDim arrays in Variant 8
Compare the number of elements in two different arrays 9
How to write to file the contents of a generic array/collection 4

Back
Top