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