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