Re: [ExcelVBA] Re: specfic character pick

 

Hi,

Do you mean...
a) Look at a sentemce to see if certain words are in it?
b) Split the sentence into words?

Also, can you please tell us what you are doing this for? Is it an assignment from a class or do you have a real purpose here?

Could you post the code that is calling your function please?

Lisa

Sent: Wed, Aug 22, 2012 1:48 pm
Subject: Re: [ExcelVBA] Re: specfic character pick

my task is to get specific words for the sentence, if they existed like tay, lay
function tay or lay.

Function FindText(txt) As String

>>
>> If (InStr(txt, "tay") > 0) Then
>> FindText = "tay"
>> ElseIf (InStr(txt, "lay") > 0) Then
>> FindText = "lay"
>> ElseIf (InStr(txt, "www") > 0) Then
>> FindText = "www"
>> Else
>> Â Â Â FindText = "Nothing"
>> End If
>>
>> End Function

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (14)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___