Understanding UserForm TabIndex

[Ark68]

I have a user form with 3 text boxes and two checkboxes.
I am looking to organize the flow of user entry as they tab out of each control. So, textbox1, textbox2, textbox3, checkbox1, checkbox2.
I've adjusted the TabIndex properties for each of those controls setting tabindex 1 to textbox1, 2 to textbox2, 3 to textbox3, 4 to checkbox1 and 5 to checkbox2. However, in runtime, tabbing does not follow that sequence. It's all over the place.

I also included labels and frames in the tab sequence thinking maybe it was those that was throwing things off, but it still didn't provide the desired flow.

Am I missing something?

 

[6StringJazzer]

In the UserForm designer, rightclick on the background of the userform and select Tab Order, and set it that way.

 

[Ark68]

Hi Jeff! Thank you for your help. This is a new concept for me, so a great learning opportunity.

Things aren't 100%. Using that dialogue. The two checkboxes are in a frame, and I have a feeling that might be causing some grief. In that tab order dialogue, the individual checkboxes aren't listed, only the frame they are in. That being said, I ordered the controls

textbox1
textbox2
textbox3
textbox4
frame1
commandbutton1
commandbutton2
label1
label2
label3
label4

So, in run time, textbox1 takes focus (cursor blinking), user enters data, tabs ... it focuses on checkbox1 (which is locked), then subsequent tabs follow this order:

checkbox2 (which is locked),
commandbutton2,
textbox1 (again)
textbox2
checkbox1
checkbox2
commandbutton2
textbox1
textbox2
textbox3
textbox4
checkbox1
checkbox2
commandbutton2

and then repeats.

Thoughts? Do I need to do anything with the tabindex values in the properties dialogue in the control properties? (ie get rid of them?)

 

[Ark68]

Thanks to RoryA, I think the solution was found here.