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

________________________________
From: "1z@compuserve.com" <1z@compuserve.com>
To: ExcelVBA@yahoogroups.com
Sent: Tuesday, August 21, 2012 9:06 PM
Subject: Re: [ExcelVBA] Re: specfic character pick


 

Good question!!!

Lisa

Sent: Tue, Aug 21, 2012 5:15 pm
Subject: Re: [ExcelVBA] Re: specfic character pick

What is the end use of this code? What are you writing it for?

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

[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 (12)

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

.

__,_._,___