| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| How do I control the cell reference when naming a cell in a macro | Excel Programming | |||
| Tab control from control to cell | Excel Programming | |||
| Control Cell Link for Option Button based on value in a cell | Excel Programming | |||
| Control Cell Link for Option Button based on value in a cell | Excel Programming | |||
Linear Mode
