Tab order with "enter" key on a sheet form
 

Hello, I am using VBA in Excel XP with Win 2000

I have a form on a sheet in which only certain cells are unlocked for user input. Protection is on so that users can "tab" through the form from entry point to entry point.

However, if the user presses "enter" (which I'm sure will be the most common method of entry) the cell pointer skips around eratically through the sheet

Is there a way to control the "enter" order under this scenario? If so, how

Thanks in advance.

Tab order with "enter" key on a sheet form
 

if you set move after return to right, it should move similar to the tab
key.

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Hello, I am using VBA in Excel XP with Win 2000.

I have a form on a sheet in which only certain cells are unlocked for user
input. Protection is on so that users can "tab" through the form from entry
point to entry point.

However, if the user presses "enter" (which I'm sure will be the most
common method of entry) the cell pointer skips around eratically through the
sheet.

Is there a way to control the "enter" order under this scenario? If so,
how?

Thanks in advance.

Tab order with "enter" key on a sheet form
 

In the Properties section, there is a tab index property. Start wit
zero for the first and go to whatever for the last.



--
Message posted from http://www.ExcelForum.com

Tab order with "enter" key on a sheet form
 

Oops, misread your post and thought you were talking about a userform.
Read Tom's reply to control movement.



--
Message posted from http://www.ExcelForum.com