Select a word in an cell
 

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