check substring of a string in Excel VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magix - 11 Dec 2005 10:57 GMT

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

Reply to this Message

Gary''s Student - 11 Dec 2005 11:19 GMT

Checkout the InStr() function in Help.

Signature

Gary's Student

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> Magix

Reply to this Message

Bob Phillips - 11 Dec 2005 15:00 GMT

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

MsgBox "Hello World" Like "*orl*"

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Checkout the InStr() function in Help.
>
[quoted text clipped - 10 lines]
> > Regards,
> > Magix

Reply to this Message