User Forms

[kylegjordan]

I created a user form with a list box and two command buttons a few months back. I recently have decided to resize it. When I do so in the user form window, the new size dimensions work when the form is called.... up until the point where I save the file. After saving it goes back to the original size. Anyone know why or what can be done to lock in the new dimensions?

Thanks,

kj

 

[logius]

Do it through code. Inside the

UserForm_Initialize

use something like this.

With Me
   .Height = 'height goes here
   .Width = 'width goes here
'etc...
End With

Granted, I have no clue why your settings aren't saving with the form, but this will make sure that the dimensions are exactly what you want them to be. Just size it up in the editor and then copy the dimensions into the proper locations. That should do it for ya. ----------------------------------------
If you are reading this, then you have read too far...

lightwarrior@hotmail.com