Find text in specific cell??

Hi,

I'm trying to write some code to determine if a specific cell contains
some text and if the booleen statement is true run the function.

I see the psuedo code something like below but are unsure of the
syntax. The Cell(4,9) actually contains the text "The Street is ..."

if Cell(4, 9) Contains "Street" then

'execute functions'

End if

Thanks

Dewey

Give this a try.

If InStr(cell.Offset(0, -8), "Street") Then
'or using your example
If Instr(Cell(4,9), "Street") Then
'execute functions

--
Best wishes,

Jim


"Dewey" wrote:

> Hi,
>
> I'm trying to write some code to determine if a specific cell contains
> some text and if the booleen statement is true run the function.
>
> I see the psuedo code something like below but are unsure of the
> syntax. The Cell(4,9) actually contains the text "The Street is ..."
>
> if Cell(4, 9) Contains "Street" then
>
> 'execute functions'
>
> End if
>
> Thanks
>
> Dewey
>
>

Thanks Jim, worked perfectly!

Jim Jackson wrote:

> Give this a try.
>
> If InStr(cell.Offset(0, -8), "Street") Then
> 'or using your example
> If Instr(Cell(4,9), "Street") Then
> 'execute functions
>
> --
> Best wishes,
>
> Jim
>
>
> "Dewey" wrote:
>
> > Hi,
> >
> > I'm trying to write some code to determine if a specific cell contains
> > some text and if the booleen statement is true run the function.
> >
> > I see the psuedo code something like below but are unsure of the
> > syntax. The Cell(4,9) actually contains the text "The Street is ..."
> >
> > if Cell(4, 9) Contains "Street" then
> >
> > 'execute functions'
> >
> > End if
> >
> > Thanks
> >
> > Dewey
> >
> >

Glad to help.
--
Best wishes,

Jim


"Dewey" wrote:

> Thanks Jim, worked perfectly!
>
> Jim Jackson wrote:
>
> > Give this a try.
> >
> > If InStr(cell.Offset(0, -8), "Street") Then
> > 'or using your example
> > If Instr(Cell(4,9), "Street") Then
> > 'execute functions
> >
> > --
> > Best wishes,
> >
> > Jim
> >
> >
> > "Dewey" wrote:
> >
> > > Hi,
> > >
> > > I'm trying to write some code to determine if a specific cell contains
> > > some text and if the booleen statement is true run the function.
> > >
> > > I see the psuedo code something like below but are unsure of the
> > > syntax. The Cell(4,9) actually contains the text "The Street is ..."
> > >
> > > if Cell(4, 9) Contains "Street" then
> > >
> > > 'execute functions'
> > >
> > > End if
> > >
> > > Thanks
> > >
> > > Dewey
> > >
> > >
>
>