[ExcelVBA] Re: specfic character pick

 

And there's the decision about whole or partial words:

cf: tay vs stay
lay vs layoff, layover, slayed

Dave G

--- In ExcelVBA@yahoogroups.com, Tayyab <sheikhtayyab@...> wrote:
>
> Now I got it. attach function selected Tay,Lay & www from the sentenence.
>
>
> Function FindText(txt) As String
> Dim a 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: Tayyab <sheikhtayyab@...>
> To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
> Sent: Wednesday, August 15, 2012 9:39 AM
> Subject: Re: [ExcelVBA] specfic character pick
>
>
>  
> I am stuck, how to pick word and  match with given condition, word size and position varies in the sentence.
>
> ________________________________
> From: David Smart <smartware.consulting@...>
> To: ExcelVBA@yahoogroups.com
> Sent: Wednesday, August 15, 2012 1:55 AM
> Subject: Re: [ExcelVBA] specfic character pick
>
>
>  
> This looks like a programming exercise. We won't do your homework for you.
> What have you written so far?
>
> Regards, Dave S
>
> ----- Original Message -----
> From: "Tayyab" <sheikhtayyab@...>
> To: <ExcelVBA@yahoogroups.com>
> Sent: Wednesday, August 15, 2012 5:12 AM
> Subject: [ExcelVBA] specfic character pick
>
> > Hello
> > I want to make a function that search specific character pick form cell.
> > The character position on cell may various. for example
> > This is John pen.
> > John leaves America.
> >
> > John will be the searching word, The function search John if find return
> > "find" other wise "not find"
> > Help me I am beginner user of VBA.
> >
> > thanks
> >
> > Regards
> > Tayyab
> >
> >
> >
> > ------------------------------------
> >
> > ----------------------------------
> > 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
> >
> > ----------------------------------Yahoo! Groups Links
> >
> >
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 10.0.1424 / Virus Database: 2437/5199 - Release Date: 08/13/12
> >
>
> [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 (7)

Recent Activity:

• New Members 5

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

.

__,_._,___