[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.

--
Rick (MVP - Excel)


"Roger on Excel" <(E-Mail Removed)> wrote in message
news:1F07760A-1D7C-43BB-B84A-(E-Mail Removed)...
> [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

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

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" <(E-Mail Removed)> wrote in message
> news:1F07760A-1D7C-43BB-B84A-(E-Mail Removed)...
> > [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
>
> .
>