Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 449
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tabbing order CandiC Excel Discussion (Misc queries) 2 September 16th 09 07:50 PM
Tabbing order in Excel form RUSH2CROCHET Excel Discussion (Misc queries) 2 September 4th 09 07:36 PM
Tabbing Order of Unproteced Cells Wayne Excel Discussion (Misc queries) 3 May 8th 09 06:54 PM
How do i setup tabbing order of cells? stephen Excel Discussion (Misc queries) 8 July 10th 08 06:15 PM
A question about Userforms and tabbing abxy[_73_] Excel Programming 0 October 8th 04 06:57 PM


All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"