Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the code below to move the active cell one row down after
making a selection from a data validation list... '------------------------------------------------------------------------- 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 '------------------------------------------------------------------------- The problem I have is when I enter a value into a cell with data validation other than list (decimal or whole number) that is above a cell with a data validation list, the active cell moves 2 rows down. Are there any ideas on how to force the active cell to the row immediately below? Thank you in advance. -M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlighting row of active cell question | Excel Discussion (Misc queries) | |||
Data Validation/Cell Protection Question | Excel Discussion (Misc queries) | |||
Data Validation: How do I hide border of ACTIVE lists? | Excel Discussion (Misc queries) | |||
Active Cell Question | Excel Discussion (Misc queries) | |||
Move Active Cell after Data Validation List | Excel Programming |