Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can have this done by following macro, to be pasted in Workbook's code
'------------------------------------------------------------------------- Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If ActiveCell.Validation.Type = xlValidateList Then ActiveCell.Offset(1, 0).Activate End If End Sub '------------------------------------------------------------------------- HTH -- AP a écrit dans le message de news: ... Ay suggestions on how I can get this done? After I make a selection from a data validation drop down list, I'd like the active cell to move one row down. Currently, the active cell stays in the cell with the data validation drop down. -M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation formula in cell and list? | Excel Discussion (Misc queries) | |||
FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT | Excel Worksheet Functions | |||
Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
How do you create a list & data validation in same cell? | Excel Worksheet Functions | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions |