Sorry,

It's not working

Cheers,

Paul

"john" wrote:

not test but this may work.
I am assuming that your textboxes are still named Texbox1, TextBox2 etc
Place code behind form. In example I have only allowed for 8 textboxes but
change as appropriate.

Hope helpful

Private Sub UserForm_Initialize()

For i = 1 To 8

Controls("TextBox" & i).TabIndex = i - 1

Next i

End Sub
--
jb


"Paul" wrote:

Hi,

I've got a userform with a lot of textboxes, comboboxes etc. During
development there was a lot dragging those boxes all over the form, and
offcourse the tabindexes are now totally off!

Is there a way to, via a macro or something, to automatically set the
tabindexes the way I would like them?

Cheers,

Paul