ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto-resizing UserForm window (https://www.excelbanter.com/excel-programming/380913-re-auto-resizing-userform-window.html)

John Bundy

auto-resizing UserForm window
 
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





All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com