control should go to next cell
 

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

control should go to next cell
 

Mir Khan,

If you are not using the menu item DataValidation 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

control should go to next cell
 

Mir Khan,

If you are not using the DataValidation 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

control should go to next cell
 

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 DataValidation 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