Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: TabIndex on a UserForm

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's what i have:

    A UserForm w/ 3 Frames
    Frame1 has 4 CommandButtons,TabIndex is,0 CommandButton1, TabIndex = 0
    CommandButton2, TabIndex = 1
    CommandButton3, TabIndex = 2
    CommandButton4, TabIndex = 3

    Frame2 has 4 ToggleButtons, TabIndex is,1
    ToggleButton1, TabIndex = 0
    ToggleButton2, TabIndex = 1
    ToggleButton3, TabIndex = 2
    ToggleButton4, TabIndex = 3

    Frame3 has 4 CheckBoxes, TabIndex is,3
    CheckBox1, TabIndex = 0
    CheckBox2, TabIndex = 1
    CheckBox3, TabIndex = 2
    CheckBox4, TabIndex = 3

    Now when i activate the UserForm i should be able to with the TabKey starting in Frame1
    move from left to right and move down to Frame2 Then to frame 3 and then back up to Frame1. It now jumps from the last CommandButton(4) and Skips Frame2 and goes to
    Frame3, sorry for being so long winded i wanted to explain the whole senario.

    James


    _________________


    [ This Message was edited by: James on 2002-05-08 16:28 ]

  2. #2
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Tab order is set by going to the objects properties and setting it's TabIndex number.
    I.E. If you have two checkboxs , Check1 & Check2 make Check1.tabindex = 0 and check1.tabindex = 1 etc.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nimrod,

    I think what you meant to say:

    I.E. If you have two checkboxs , Check1 & Check2 make Check1.tabindex = 0 and check2.tabindex = 1 etc.

    What am i missing here, i think what your suggesting is exactly what i've already done?

    James

    _________________


    [ This Message was edited by: James on 2002-05-08 16:34 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK here's the difference the "fau paux":
    When the UserForm is activated the ToggleButtons in Frame2 are "up", so.... if i use the "TabKey" starting in Frame1 it STILL skips Frame2 and jumps into Frame3. BUT if i click once on the 4 ToggleButtons in Frame2 FIRST and then go into Frame1 and use the "TabKey" everything works fine? So that tells me that before the UserForm is activated the ToggleButtons have to be an "inny" opposed to an "outy"

    James


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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