Tab index Property

**dougman824** · 01-09-2018, 05:27 PM

Hello,

I have a huge userform with a bunch of controls on it that I need to set the tab index for. I have between 200 and 60 controls on 6 different pages that follow a name & number type naming. I wanted to change the index in a loop rather than click and change a whole bunch of times. Is this possible?

Side note for if it matter:
The controls are in a frame (each named by a **Frame) that is on a multipage(named multipage2) that is on a multipage(named multipage1) on a form (named fsrform)

Please Login or Register  to view this content.

Here is what I tried:

**xlnitwit** · 01-09-2018, 05:50 PM

If you are trying to make a permanent change, you either need to do it manually at design time, or use code to alter the properties using the Designer property of the VBComponent. Manually is usually not that arduous if you simply select the controls in order using the Ctrl key and then type 0 as the tab index for the first control in the properties window- all the others will be ordered based on the order you clicked them.

**dougman824** · 01-09-2018, 05:54 PM

What is the designer property?

And the for the ctrl method if I type in like 5 it would count as the first as 5 next 6 ect right?

**xlnitwit** · 01-09-2018, 06:00 PM

Yes, that's correct.

For the designer, you would use code like this

Please Login or Register  to view this content.

Note that the form cannot be loaded when you run that code.

**Norie** · 01-09-2018, 06:15 PM

Have you tried right clicking the form and selecting Tab Order?

That will give you a dialog where you can change the order of controls (and groups of controls).

**dougman824** · 01-09-2018, 06:23 PM

What do you mean by the form can not be loaded?

**xlnitwit** · 01-09-2018, 06:28 PM

I mean that it won't work if the form is currently loaded. As long as you haven't loaded it in code, you should be fine. This is not code that you put in the forms' Initialize event for example- you just run it once from a module.

**dougman824** · 01-09-2018, 06:37 PM

So as long as I don't have the form running it should work?

I had an issue with it and I closed the file opened it and went directly to the code that matches what you posted and ran it. The values did not change. Could I maybe have to do an unload FSRform?

**xlnitwit** · 01-09-2018, 06:40 PM

If you never loaded the form you should not have to unload it- and you should get an error running the code if the form is loaded. Can you post the workbook?

**dougman824** · 01-09-2018, 06:49 PM

I can't post the full workbook due to company contracts but I can post the form and if it works then I can just reimport it.

If you go to the systems page you will find 7 other pages. On there the last 6 have rows with 4 controls in a frame that follow a similar naming convention with just a few letter changes for each page.

I would like to tab from employee name to employee primary title to job description to Shift then the next row.