Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've created a survey for teachers to complete on each one of their students.
It has 14 items. Student's name is in column A, item 1 in column B, item 2 in column C, etc. When the teacher. I have the cursor moving from left to right. When the teacher enters a value for item 14 I want the cursor to automatically go back to the next row in column A. How? I haven't a clue. I've used validation to force a response of 0, 1, 2 or 3. I've made sure my source list doesn't include blank/empty cells. I do not want the teachers to be able to leave blanks. I've uncheck "ignore blanks". I've locked cells I want locked and made sure the cells the teachers will enter the data in are unlocked. I've protected the sheet. When I test the validation it allows blank/empty cells. What have I done wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving macro response into a dated list | Excel Discussion (Misc queries) | |||
moving the cursor in a macro | Excel Discussion (Misc queries) | |||
moving cursor | Excel Worksheet Functions | |||
moving cursor | New Users to Excel | |||
Forcing the cursor to move to A of the next line after D of the pr | Excel Discussion (Misc queries) |