View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz quartz is offline
external usenet poster
 
Posts: 35
Default 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.