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