begins with, not equals, using activecell.value
 

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

begins with, not equals, using activecell.value
 

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

begins with, not equals, using activecell.value
 

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