Tab order with "enter" key on a sheet form

[Guest]

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.

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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.

 

[kkknie]

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

 

[kkknie]

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