Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easier method for inserting object in cell | Excel Discussion (Misc queries) | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
Easier Method | Excel Programming | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
method for arrange items in alphabetic order in a sheet | Excel Worksheet Functions |