Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 249
Default Changing Tab order - easier method??

[Excel 2003]

I have a userform with hundreds of textboxes on it

They are not in any particular Tab order and rearranging them is going to be
a major undertaking to put them in a sensible order

Is there an easier way to change the Tab order without using the tiny dialog
box in the VBA window?

Many Thanks,


Roger
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default Changing Tab order - easier method??

An alternative to using the Tab Order dialog is to select your controls one
at a time in the REVERSE order that you want them to be numbered in and set
the TabIndex property to 0 (ZERO) for EACH control that you select. The
second time you set a control's TabIndex to 0, the previous control whose
TabIndex was 0 will have it renumber to 1. The third time, the TabIndex 0
goes to TabIndex 1 and the prior control with TabIndex 1 gets bumped up to
TabIndex 2, and so on. That is why you pick the controls in the reverse
order that you want them numbered in.

--
Rick (MVP - Excel)


"Roger on Excel" wrote in message
...
[Excel 2003]

I have a userform with hundreds of textboxes on it

They are not in any particular Tab order and rearranging them is going to
be
a major undertaking to put them in a sensible order

Is there an easier way to change the Tab order without using the tiny
dialog
box in the VBA window?

Many Thanks,


Roger


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Changing Tab order - easier method??

Hi,

Yes, there's a much easier way. Right click the userform and select 'Tab
Order' and in the popup sort to how you want it.

Mike

"Roger on Excel" wrote:

[Excel 2003]

I have a userform with hundreds of textboxes on it

They are not in any particular Tab order and rearranging them is going to be
a major undertaking to put them in a sensible order

Is there an easier way to change the Tab order without using the tiny dialog
box in the VBA window?

Many Thanks,


Roger

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 249
Default Changing Tab order - easier method??

Thanks Rick,

I will give that a try - will let you know how it works out

Roger

"Rick Rothstein" wrote:

An alternative to using the Tab Order dialog is to select your controls one
at a time in the REVERSE order that you want them to be numbered in and set
the TabIndex property to 0 (ZERO) for EACH control that you select. The
second time you set a control's TabIndex to 0, the previous control whose
TabIndex was 0 will have it renumber to 1. The third time, the TabIndex 0
goes to TabIndex 1 and the prior control with TabIndex 1 gets bumped up to
TabIndex 2, and so on. That is why you pick the controls in the reverse
order that you want them numbered in.

--
Rick (MVP - Excel)


"Roger on Excel" wrote in message
...
[Excel 2003]

I have a userform with hundreds of textboxes on it

They are not in any particular Tab order and rearranging them is going to
be
a major undertaking to put them in a sensible order

Is there an easier way to change the Tab order without using the tiny
dialog
box in the VBA window?

Many Thanks,


Roger


.

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
easier method for inserting object in cell Radhakant Panigrahi Excel Discussion (Misc queries) 0 April 22nd 10 03:59 PM
How to change series plotting order without changing legend order? PatrickM Charts and Charting in Excel 6 December 2nd 09 08:43 PM
Easier Method Steven Excel Programming 2 May 21st 08 11:58 PM
How stop Excel file UK date order changing to US order in m.merge Roger Aldridge Excel Discussion (Misc queries) 1 October 9th 07 11:52 PM
method for arrange items in alphabetic order in a sheet Anas Excel help! Excel Worksheet Functions 1 August 6th 06 10:09 AM


All times are GMT +1. The time now is 12:40 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"