Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jul 2006
    Location
    Colleyville, Texas, USA
    Posts
    45
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Control Tab Order (2003 SP3)

    Is there a way to control the order in which cells are accessed by tabbing?

    My form has two columns, one for the borrower, and one for the co-borrower, to enter information.

    I'd like to have the tab move through each row of the borrower's column, and then move through each row of the co-borrower's column.

    Diane

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Control Tab Order (2003 SP3)

    You could use Enter instead of Tab - Enter usually moves down.
    If you select a range of cells in two columns, Enter will move down the first column, then down the second column, and back to the first one.

  3. #3
    Lounger
    Join Date
    Jul 2006
    Location
    Colleyville, Texas, USA
    Posts
    45
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Control Tab Order (2003 SP3)

    Enter would work for that section of my form; but then there are sections where tabbing is better. Selecting a range of cells would work if "I" were entering the data. However, all of these variations are probably too confusing for our borrowers to understand ... many who know almost nothing about Excel. <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    I'm hoping I can control their order as in Access.

    Diane

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Control Tab Order (2003 SP3)

    Setting the tab order for cells is not really easy in Excel.
    Perhaps you could design a userform in the Visual Basic Editor. You can bind text boxes on a userform to cells on a worksheet, and you can set the tab order for controls of a userform, just like for a form in Access.

Posting Permissions

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