Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement - begins with | Excel Discussion (Misc queries) | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) |