Re: Substring check within VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
Date: Sat, 6 Aug 2005 15:02:02 +0100

You can also use

If str2 like "*" & str1 & "*" Then
....

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Gary's Student" <GarysStudent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B0AF671-A4BA-4B43-9036-B6425DE80C85@xxxxxxxxxxxxxxxx
> If Str1 and Str2 are strings, is there a function or simple coding within
VBA
> to return TRUE if Str1 is a substring of Str2, otherwise FALSE?
>
> Thanks in advance
> --
> Gary's Student

.

References:
- Substring check within VBA
  - From: Gary's Student

Prev by Date: Re: goto function
Next by Date: Showing criteria in custom filter
Previous by thread: Re: Substring check within VBA
Next by thread: One Excel Form for All worksheets Lists
Index(es):
- Date
- Thread

Relevant Pages

Re: Streitfrage
... Parameter sollten als eigene Verwendungen von Strings gezählt werden, und eine Zuweisung an Str1 oder Str2 sollte dann die lokale Variable s nicht ändern. ...
(de.comp.lang.delphi.misc)
Re: character byte str[i] treated as signed, I need unsigned
... Susan Rice wrote: ... How are str1, str2 and i declared? ... You should know that knee-jerk "this'll fix it" responses may not be ...
(comp.lang.c)
Re: Own implementation of GetHashCode()
... You could concatenate str1 and str2 and then use that hash code, ... > public override int GetHashCode() ...
(microsoft.public.dotnet.languages.csharp)
Re: 32 or 64 bit processor info in C
... snip ... ... foo(char *str1, char *str2) ...
(comp.lang.c)
Re: 32 or 64 bit processor info in C
... snip ... ... foo(char *str1, char *str2) ...
(comp.lang.c)