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.

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.

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