Well, just to give another version of what you could use ...

Option Explicit
Sub FindTheWhiteRabbit()
If c.Text Like "*abc*" Then MsgBox "Found in string."
End Sub

... but the InStr function (as previously mentioned) works just as well. :)


--
Regards,
Zack Barresse, aka firefytr


"peacelittleone"
<peacelittleone.1tawim_1123261540.0021@excelforu m-nospam.com wrote in
message news:peacelittleone.1tawim_1123261540.0021@excelfo rum-nospam.com...

Say I have a string = "abc".
Say I have a cell value = "123 abc 456 def"

In VB how do I findout if the cell value contains my string?

Right now I am trying this: (which of course doesn't work)

Set Found = Find(c.Value, req.Value, 1)

Where c is my string and req is the cell value I want to look in.

TIA!!!!

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile:
http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=393364