Re: [ExcelVBA] Re: specfic character pick

 

whole word lay is itself word and layout not...but Instr is not working "layout" word. my requirement is to find "lay" and ignore "layout"
please help me.

thanks

________________________________
From: dmgathmann <dmgathmann@yahoo.com>
To: ExcelVBA@yahoogroups.com
Sent: Monday, August 20, 2012 4:30 PM
Subject: [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]
>

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

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

.

__,_._,___