![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Huntington Beach, CA USA
Posts: 327
|
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 |
|
MrExcel MVP
Join Date: Apr 2002
Location: Vancouver BC , Canada
Posts: 6,259
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Huntington Beach, CA USA
Posts: 327
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Huntington Beach, CA USA
Posts: 327
|
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 |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|