ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximize Userform (https://www.excelbanter.com/excel-programming/293817-maximize-userform.html)

Swift2003

Maximize Userform
 
I've created userforms to show\alter spreadsheets everything works not a
problem. But i ran it on a different computer with a lower res and the
userforms went off the side of the screen. Any1 know some sort of
userform maximize code ?? greatfull 4 any help


---
Message posted from http://www.ExcelForum.com/


Tom Ogilvy

Maximize Userform
 
Here are some options

1)Design for the lowest resolution you will use

2)Have multiple userforms, one for each resolution

3)have your code move and space all your controls and then size the userform

4) use a scrolling userform

5) look at the zoom property of the userform

--
Regards,
Tom Ogilvy


"Swift2003 " wrote in message
...
I've created userforms to show\alter spreadsheets everything works not a
problem. But i ran it on a different computer with a lower res and the
userforms went off the side of the screen. Any1 know some sort of
userform maximize code ?? greatfull 4 any help


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 10:26 PM.

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