check substring of a string in Excel VBA

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

Checkout the InStr() function in Help.
--
Gary's Student


"magix" wrote:

> 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)

"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> Checkout the InStr() function in Help.
> --
> Gary's Student
>
>
> "magix" wrote:
>
> > 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
> >
> >
> >