VBA- Contains any element
 

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.

VBA- Contains any element
 

Look at the InStr function in VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"digiphotogirl" wrote in message
...
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.