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

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

Would the InStr function work for you?

Best regards

John

"oodam" wrote in message
...

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

Try using Instr:

If InStr(Cells(1, 1), MyStr) 0 Then MsgBox "Found it"



"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

You could try using Instr that will return a value 0 if the string is
found. e.g.

If Instr(string1, string2) 0 then
'found
else
'not found
end if

Where string2 is the string to search for in string1. It is case sensitive
as shown
--
Cheers
Nigel



"oodam" wrote in message
...

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

Thanks everyone for your help. Much to my surprise, it actually seems
to be working!


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

You probably want to use the InStr function to determine if your substring
exists in the full string. If Instr returns a value then you have found your
substring, otherwise not.

--
HTH...

Jim Thomlinson


"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