Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Aug 2005
    Posts
    3

    Question Tabbing in Excel Form

    I'm using Excel 2000. I have created a form in MS Excel for user input. I have unlocked the cells I want the users to input into, then protected the sheet. When the user presses the tab key the focus changes to the next unlocked cell. How do I change the order in which the tab key takes the user from cell to cell?

  2. #2
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Tabbing in Excel Form

    Hi, when you say "form" your meaning just some data in a sheet not a VBA Userform correct?

    In the case of tabbing in a sheet, the direction is by default left to right then down. If you want to change the order then you would have to re-arrange the data on the sheet so it meets your requirements. However, it could be done with code but seems over-the-top when you could easily amend the sheet.

    You can amend the direction after you press the enter key by amending the options under Tools|Options|Edit tab then changing the move selection after enter option. However, this will move to both protected and non-protected cells alike.

Similar Threads

  1. Help with CGI for a Web Form
    By DeSade in forum PressF1
    Replies: 19
    Last Post: 24-05-2007, 11:27 AM
  2. Form help
    By Timbo in forum PressF1
    Replies: 10
    Last Post: 24-08-2006, 03:56 PM
  3. Replies: 7
    Last Post: 04-01-2005, 12:46 PM
  4. Tabbing IE
    By Mantis in forum PressF1
    Replies: 7
    Last Post: 30-12-2003, 02:31 PM
  5. Submission form
    By in forum PressF1
    Replies: 3
    Last Post: 21-11-2001, 05:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •