Hi again

No, that's pretty impossible. But when you way "wrong order", does that apply to bound
spreadsheet cells or simply Tab order ? The latter is fixed by rightclicking the form in
design time and adjusting the list.

Also, a userform has an event called

Private Sub UserForm_Initialize()

code here runs before the form is loaded/displayed, and would be the ideal place to put
your existing "move boxes" code. I guess/hope this is the workaround you look for. Put
this in the Userform module, nowhere else:

Private Sub UserForm_Initialize()
TextBox2.top = 50
TextBox2.left = 10
TextBox3.top = 10
TextBox3.left = 100
End Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Garry Jones" wrote in message ...
Harald Staff wrote:

If I understand your problem right, do some reading on the terms "design time" and
"run time".

Yep, that's the one.

I am in design time. I placed 198 text boxes in a formula. But I placed
them in the wrong order. Now I thought I'd be smart (but failed) and
move them in design with VB code. Of course I can grab them all one by
one and move them by hand (mouse) and this would save me time today.
However, in the (near) future I may want to move them around again until
I am happy with their placement. And if I have the code syntax I'll just
have to enter the new required values.

So what I am looking for is a feature to move text boxes around within a
userform whilst still in design stage. And when that is done, "save
current changes to userform appearance".

Ìs there a workaround for this?