tab order in forms

[opopanax666]

Hi guys & gals,

why doesn't vba respect the tab order entered in, euh, "Tab order"? I mean, I made a userform with a dozen or so inputs, I want it to cycle through them in a particular order, so entered that order in "Tab order", I check the "Taborder"-attributes of each input, and they are correct (0 to 11), but when I launch the d@mn thing, the cursor sits in input #6, looking stupid. There, I said it!..
Seriously now, anybody have a clue as to why, when everything seems ok, it still doesn't work?

[royUK]

How have you set the Tab Order?
You need to right click on the UserForm in the VB Editor & choose Tab Order.

[opopanax666]

Weeeelll, I don't know, what do you think I did? Let's see:

so entered that order in "Tab order", I check the "Taborder"-attributes of each input, and they are correct

Sorry for the sarcasm, "but the field was wide open"...

[royUK]

only you know what you've done. If you have set the Tab order correctly then you shouldn't have a problem. if you want to be rude, maybe you think clever, then you can help yourself!

[Leith Ross]

Hello opopanax666,

VBA respects the tab order, but it is control creation order that dictates which control will receive the focus once the UserForm is displayed. If you input control is a TextBox you can direct which one will have the cursor by using the code below. Just change the TextBox name to match the one you want to be first.

Private Sub UserForm_Activate()
  TtextBox1.SetFocus
EndSub

Now the tabbing will start from this control. If its tab order is 0 (zero) then the next control will be the one whose tab order is 1.

Sincerely,
Leith Ross

[opopanax666]

Hello opopanax666,

VBA respects the tab order, but it is control creation order that dictates which control will receive the focus once the UserForm is displayed. If you input control is a TextBox you can direct which one will have the cursor by using the code below. Just change the TextBox name to match the one you want to be first.

Private Sub UserForm_Activate()
  TtextBox1.SetFocus
EndSub

Now the tabbing will start from this control. If its tab order is 0 (zero) then the next control will be the one whose tab order is 1.

Sincerely,
Leith Ross

Marvellous, works like a charm...

Cheers, matey!