check substring of a string in Excel VBA

M

magix

Hi,

How do I check the subtring of a string ? I don't think I can use Strcomp.

Let say I have string "Hello world"

The Substring that I want to find is "orl"

What function can I use?

Regards,
Magix
 
B

Bob Phillips

Or if you just want to know if the string contains "orl", use

MsgBox "Hello World" Like "*orl*"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

Text string searches 3
search text for substring and change text colour of substring 5
Error 2042 3
vba help 6
EXTRACTING SUBSTRINGS !! 11
vlookup where the query is a substring 3
Help with Replace() 11
Substring formula to work with string value has numeric 5

Top