Hi Experts i have a question...

I have an excel where column B has a drop down with Y,N, and NA in it in
each cell. now what i want is if option Y is chosen the control should go to
the next cell below it.

Thanks

Mir Khan,

If you are not using the menu item Data>Validation then you could use
activecell.offset(1,0).select


"Mir Khan" wrote:

> Hi Experts i have a question...
>
> I have an excel where column B has a drop down with Y,N, and NA in it in
> each cell. now what i want is if option Y is chosen the control should go to
> the next cell below it.
>
> Thanks

Mir Khan,

If you are not using the Data>Validation method then try this

activecell.offset(1,0).select

"Mir Khan" wrote:

> Hi Experts i have a question...
>
> I have an excel where column B has a drop down with Y,N, and NA in it in
> each cell. now what i want is if option Y is chosen the control should go to
> the next cell below it.
>
> Thanks

You could use the selection_change event of a worksheet

If target = "Y" then Selection.Offset(1,0)

Else

'Do Nothing

End If
--
BerbatovIsGod


"JRForm" wrote:

> Mir Khan,
>
> If you are not using the Data>Validation method then try this
>
> activecell.offset(1,0).select
>
> "Mir Khan" wrote:
>
> > Hi Experts i have a question...
> >
> > I have an excel where column B has a drop down with Y,N, and NA in it in
> > each cell. now what i want is if option Y is chosen the control should go to
> > the next cell below it.
> >
> > Thanks