How to check if a variable exists within another variable

[Xs4all]

Hi,

I have 2 variables:

A="Fox"
B="The quick brown fox"

How can I check if variable B contains variable A? Something like: "IF (A is
part of B) THEN TRUE"

Is that possible in VBA?

Thanks

 

[Jonathan West]

Hi,

I have 2 variables:

A="Fox"
B="The quick brown fox"

How can I check if variable B contains variable A? Something like: "IF (A
is part of B) THEN TRUE"

Is that possible in VBA?

Thanks

Look up the InStr function in VBA Help. Also look up "Like", "LCase" and
"UCase". There are code examples in the Help which will point you in the
right direction.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Jezebel]

if instr(B,A) > 0 then
...

 

[Xs4all]

Perfect!!

Thanks

if instr(B,A) > 0 then
...

 

[Xs4all]

Thanks!

Look up the InStr function in VBA Help. Also look up "Like", "LCase" and
"UCase". There are code examples in the Help which will point you in the
right direction.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org