Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing tabbing order in Userforms
When I create a new form the tabbing order seems to get set according to the
order in which the coltrols are inserted. However, if I later decide I have to put in a new control in then middle of the ones created earlier the resulting tabbing order is jumbled when the form is used. So, I seek to revise the order so tabbing goes from top to bottom and from left to right. The problem is if I reset the TabIndexes in the properties sheet they don't stick. I.e., if I change the TabIndex for a control for 23 to 2, then 14 to 3, etc, when I go back to those controls later the tab indices have changed to something else. How do I force it to keep the indicies I assign? TIA Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing tabbing order in Userforms
Hi Ed
Rightclick the userform, select Tab order and do your things there. Note that Frames, multipages and other containers need individual treatment. HTH. Best wishes Harald "Ed Sowell" wrote in message ... When I create a new form the tabbing order seems to get set according to the order in which the coltrols are inserted. However, if I later decide I have to put in a new control in then middle of the ones created earlier the resulting tabbing order is jumbled when the form is used. So, I seek to revise the order so tabbing goes from top to bottom and from left to right. The problem is if I reset the TabIndexes in the properties sheet they don't stick. I.e., if I change the TabIndex for a control for 23 to 2, then 14 to 3, etc, when I go back to those controls later the tab indices have changed to something else. How do I force it to keep the indicies I assign? TIA Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing tabbing order in Userforms
Thanks, Harold!
Ed "Harald Staff" wrote in message ... Hi Ed Rightclick the userform, select Tab order and do your things there. Note that Frames, multipages and other containers need individual treatment. HTH. Best wishes Harald "Ed Sowell" wrote in message ... When I create a new form the tabbing order seems to get set according to the order in which the coltrols are inserted. However, if I later decide I have to put in a new control in then middle of the ones created earlier the resulting tabbing order is jumbled when the form is used. So, I seek to revise the order so tabbing goes from top to bottom and from left to right. The problem is if I reset the TabIndexes in the properties sheet they don't stick. I.e., if I change the TabIndex for a control for 23 to 2, then 14 to 3, etc, when I go back to those controls later the tab indices have changed to something else. How do I force it to keep the indicies I assign? TIA Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tabbing order | Excel Discussion (Misc queries) | |||
Tabbing order in Excel form | Excel Discussion (Misc queries) | |||
Tabbing Order of Unproteced Cells | Excel Discussion (Misc queries) | |||
How do i setup tabbing order of cells? | Excel Discussion (Misc queries) | |||
A question about Userforms and tabbing | Excel Programming |