Changing Tab order - easier method??

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

[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
 
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.
 
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
 
Thanks Rick,

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

Roger

Rick Rothstein said:
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 said:
[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
Click to expand...

.
Click to expand...
 
Back
Top