View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mat mat is offline
external usenet poster
 
Posts: 37
Default "Enter" key to work as "tab"

Hi,

I am preparing a form for the sales team. I want them to type the
information only in certain cell and when they key "Enter" it should go the
the specified cell. This function is workable with "Tab" key (Using Protect
Sheet Function) but i want it to work with the "tab" as well as "enter" key .

For Example: If the data is entered in cell A5 and if the user hits "Enter"
the cursor should go in Cell A7 after that when it is hit Enter" the cursor
should go to cell D7.

Thanks and Regards