Changing Tab order - easier method??

[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

 

[Rick Rothstein]

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.

 

[Mike H]

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]

Thanks Rick,

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

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.

--
Rick (MVP - 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

.