Excel help please

Discussion in 'Technical queries' started by flyer, 12 Apr 2019.

  1. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    964
    In a locked spreadsheet, I want the user to be able to tab from one cell to another in an order that I set, not just to the next unlocked cell from left to right.

    This will allow you to tab from all the cells in section A of the spreadsheet and then tab between all of the cells in section B and so on. At the moment, when you enter a value in the first cell of section A and then press tab, you move across into section B and so on.

    Is it possible to have the tab key move the curser to each required cell in section A until its completed, then move to section B, section C etc

    Thanks
     
  2. aguero93:20

    aguero93:20

    Joined:
    21 Oct 2013
    Messages:
    72,036
    Location:
    The Guardiola Circle Jerk
    Team supported:
    Team Pep
    (Right click page)Design view - tools - tab order.

    You should be able to change it from there. Laborious though.
     
  3. peace frog

    peace frog

    Joined:
    9 Jan 2009
    Messages:
    8,856
    Location:
    best friend of rabin :)
    sausages
     
    flyer likes this.
  4. mindmyp's_n_q's

    mindmyp's_n_q's

    Joined:
    5 Oct 2010
    Messages:
    4,860
    Location:
    Now in 109
    No idea if this is what you are after.

    First part of the video

     
  5. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    964
    Thanks for the help everybody especially the sausages. I'll try the other two suggestions over the weekend and let you know how I get on

    Thanks again
     
  6. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    964
    Sorted it with this, found it on the internet, no idea what it means but putting your info with this I managed to get the result I wanted.

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim tabArray As Variant
    Dim i As Long
    tabArray = Array("B5", "C6", "D7", "E8")
    Application.ScreenUpdating = False
    For i = LBound(tabArray) To UBound(tabArray)
    If tabArray(i) = Target.Address(0, 0) Then
    If i = UBound(tabArray) Then
    Me.Range(tabArray(LBound(tabArray))).Select
    Else
    Me.Range(tabArray(i + 1)).Select
    End If
    End If
    Next i
    Application.ScreenUpdating = True
    End Sub

    Just substituted the tabArray = Array cells to the ones I wanted
     
  7. aguero93:20

    aguero93:20

    Joined:
    21 Oct 2013
    Messages:
    72,036
    Location:
    The Guardiola Circle Jerk
    Team supported:
    Team Pep
    Fuck me I thought my version was laborious. You were trying to create a data form right?
     
  8. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    964
    It took a while mate but it's done now. What's a data form?
     
  9. aguero93:20

    aguero93:20

    Joined:
    21 Oct 2013
    Messages:
    72,036
    Location:
    The Guardiola Circle Jerk
    Team supported:
    Team Pep
    A form for others to fill with information.
     
  10. flyer

    flyer

    Joined:
    22 May 2004
    Messages:
    964
    That's exactly what it is. A pricing spreadsheet for sales people
     

Share This Page