David,
If you are referring to the size of the window containing the userform when
designing, then no, unless you want to write an add-in to do it for you.
However, for me (XL2K+XL2002), the size of the window remains the same after
opening/closing the window and/or the file.

NickHK

"#DIV/0" wrote in message
...
Does anyone know of a way to force the frame of a UserForm window to be
closer to the size of the form you're working on ?
It gets really annoying when you have 4 or 5 forms in a project and every
time you open the form again the window is so much larger than necessary.
I
seem to spend a lot of time grabbing the corners of windows to resize
them...

--
David M