begins with, not equals, using activecell.value

[crimsonkng]

What's the VB command, in an Excel macro, to determine if a cell begins with
certain words?

Quite frequently, I use the command: If ActiveCell.Value = "Specific Words"
Then etc.

But now I want to search for a cell that begins with the words "Up to ..."
But the rest of the sentence can be 150 different things so it's not
practical for me to search for every combination of words.

So, how do I say "if the cell begins with the words 'Up to' Then ...?

I searched on the web and in Excel "help" and became thoroughly confused.
Thanks, in advance.

Dan

[Jim Thomlinson]

Here is one possiblity

If ActiveCell.Value Like "Up to*" Then MsgBox "Found"

You could also use InStr function to find the position of a phrase within a
string...
--
HTH...

Jim Thomlinson


"crimsonkng" wrote:

> What's the VB command, in an Excel macro, to determine if a cell begins with
> certain words?
>
> Quite frequently, I use the command: If ActiveCell.Value = "Specific Words"
> Then etc.
>
> But now I want to search for a cell that begins with the words "Up to ..."
> But the rest of the sentence can be 150 different things so it's not
> practical for me to search for every combination of words.
>
> So, how do I say "if the cell begins with the words 'Up to' Then ...?
>
> I searched on the web and in Excel "help" and became thoroughly confused.
> Thanks, in advance.
>
> Dan

[crimsonkng]

Like! I should have known.
It works perfectly. Thanks.
Dan

"Jim Thomlinson" wrote:

> Here is one possiblity
>
> If ActiveCell.Value Like "Up to*" Then MsgBox "Found"
>
> You could also use InStr function to find the position of a phrase within a
> string...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "crimsonkng" wrote:
>
> > What's the VB command, in an Excel macro, to determine if a cell begins with
> > certain words?
> >
> > Quite frequently, I use the command: If ActiveCell.Value = "Specific Words"
> > Then etc.
> >
> > But now I want to search for a cell that begins with the words "Up to ..."
> > But the rest of the sentence can be 150 different things so it's not
> > practical for me to search for every combination of words.
> >
> > So, how do I say "if the cell begins with the words 'Up to' Then ...?
> >
> > I searched on the web and in Excel "help" and became thoroughly confused.
> > Thanks, in advance.
> >
> > Dan