Problem tabbing through a UserForm in order

[nkemp15]

I have a UserForm with lots of drop downs and text boxes. Currently if filling out the form and hitting tab, it will go through all the textboxes first, then start back at the top and tab through the drop downs.

Is there a way to arrange each field so it starts at the beginning and works it's way through in the order that I added them?

 

[ParamRay]

.
.

If you view the code in your UserForm's module, there's a property called TabIndex. Click on each control and give the tab index a number from 1 to however many controls you have in your user form. That way, pressing the tab key on the keyboard cycles through the controls in order of the tab index...

 

[ParamRay]

.
.

If you view the code in your UserForm's module, there's a property called TabIndex. Click on each control and give the tab index a number from 1 to however many controls you have in your user form. That way, pressing the tab key on the keyboard cycles through the controls in order of the tab index...

If you have lots of frames in your user form then you also have to set the tab index for each frame...

 

[Norie]

Right click the form, select Tab Order and move the controls up/down as needed using the arrow buttons.