You can use the Like keyword for wildcard comparisons:

If strCellValue Like "*" & strTest & "*" Then...

Be aware that it's case-sensitive, so "A" is not Like "a". If
you need case-insentivity use something like

If LCase(strCellValue) Like "*" & LCase(strTest) & "*" Then...

Andrew


oodam wrote:
I'm trying to use a formula that will check the contents of a cell and
color the cell's row accordingly. However, the "keywords" that I'm
looking for won't be the only thing in the cell - they will most likely
be part of a sentence.
With regular formulas, I found that just putting asterisks around the
keywork insde quotation marks works fine. In VBA, though, that doesn't
seem to work.
Any ideas?


--
oodam
------------------------------------------------------------------------
oodam's Profile: http://www.excelforum.com/member.php...o&userid=35513
View this thread: http://www.excelforum.com/showthread...hreadid=553317