Look at the userform properties, you can set the top,left,height,width and
look at the seetings for startupposition

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"#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