Tab order with "enter" key on a sheet form

Q

quartz

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.
 
T

Tom Ogilvy

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

--
Regards,
Tom Ogilvy

quartz said:
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
Click to expand...
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
Click to expand...
common method of entry) the cell pointer skips around eratically through the
sheet.
 
K

kkknie

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

kkknie

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