Tjena Garry

You have to save the settings somewhere and read them back on next load. Within the file,
in another excel file, in a text file, in the registry, in an ini file, in a database,
anywhere. Between sesions, this is. If it's only for the same session then some available
variables will do. (But saving/restoring the user's last settings between sessions is a
nice thing to do anyway).
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Garry Jones" wrote in message ...
I need to move 200 text boxes on a formula.

Instead of moving them by hand I have written some code behind a command
button.

For instance
____________________________________
Private Sub CommandButton1_Click()

UserForm1.TextBox1.top = 10
UserForm1.TextBox1.width = 20
UserForm1.TextBox1.left = 10

End Sub
____________________________________

When I click the command box they move.

But the next time I open the form they are back to the old postions. How
do I get them to maintain the property I set with the button?

Garry Jones
Sweden