Q1

Instruct user to employ the Tab key to move from A to B then hit Enter key
when leaving B

Q2

Perhaps you have disabled "show error alert etc"

Additional information...............You misunderstand the purpose of
"ignore blanks"

Blank Cells in Source List

If the source list is a named range that contains blank cells, users may be
able to type any entry, without receiving an error message.

You say you have no blanks but I would suggest you re-enable "Ignore Blanks"


Gord Dibben MS Excel MVP

On Fri, 7 Aug 2009 08:22:02 -0700, psychobug
wrote:

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?