[vba-newbie] testing cell text for specific characters?

I would like to test the text value of a cell to determine if it
includes a certain string of characters and set a variable to true when
appicable.

In other words, something like this (unknown method in human syntax and
italics) :

-If Range["A1"] text string includes 'thisText' Then-
boolVariableName = True
End If

Is there a built -in way to do this with VBA? I'm sure there is, but I
haven't been able to locate the appropriate funtion in the help files,
this forum, or via google. Can anyone assist?


---
Message posted from http://www.ExcelForum.com/

One way:

boolVariableName = InStr(Range("A1").Text, "thisText") 0


In article ,
counterform wrote:

I would like to test the text value of a cell to determine if it
includes a certain string of characters and set a variable to true when
appicable.

In other words, something like this (unknown method in human syntax and
italics) :

-If Range["A1"] text string includes 'thisText' Then-
boolVariableName = True
End If

Is there a built -in way to do this with VBA? I'm sure there is, but I
haven't been able to locate the appropriate funtion in the help files,
this forum, or via google. Can anyone assist?


---
Message posted from http://www.ExcelForum.com/