check substring of a string in Excel VBA

  • Thread starter Thread starter magix
  • Start date Start date
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
 
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)
 
Back
Top