Hi OssieMac,

Thanks for the reply. And yes, your example help me to some extent in the
process of getting to my goal. The codes just find a "whatever" we have
defined only. Still I appreciate your help.

Regards,
Westman

"OssieMac" wrote:

Will this example help?
Sub Test_InString()

Dim myString
Dim myPos

myString = "I like to eat fried chicken"
StrToFind = "eat"

myPos = InStr(1, myString, StrToFind, 1)
If mypos 0 Then
MsgBox ("Found string starting at character " & mypos)
End If


End Sub


"Westman" wrote:

Hi,

I'm facing a problem in developing my excell addin. How do I select just one
word from a sentences in a single cell? For example:-

I like to eat fried chicken. -- This sentence is in a cell.

Right now, I just want to select word "eat" from the above sentence. Is this
posible? If posible, how do I accomplish that?

Regards,
Westman