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 |
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 |
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 |
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 . |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com