ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform Size (https://www.excelbanter.com/excel-programming/299626-userform-size.html)

richard

Userform Size
 
I have a userform which needs to be used by people using
laptops and desktops, all with different sized screens.

To solve the problem of them not seeing some parts of the
userform, i have put in some option butttons where they
can select the size:
userform1.zoom = 75%
and so on.

This only seems to zoom the objects on the userform
though, not the actual userform itself.

Is there a zoom funciotn for the userform window as well?

Thanks in advance

Richard


nath

Userform Size
 
You could try using the width and height properties of the
userform.

i.e. (assuming your using an option button to change)

std_height = 400:std_width = 400

' option button 1 selects lap tops

if optionbutton1.value = true then
userform1.height = (std_height *0.75)
userform1.width= (std_width*0.75)
else
userform1.height = std_height
userform1.width= std_width
end if

Hope this helps

Nath
-----Original Message-----
I have a userform which needs to be used by people using
laptops and desktops, all with different sized screens.

To solve the problem of them not seeing some parts of the
userform, i have put in some option butttons where they
can select the size:
userform1.zoom = 75%
and so on.

This only seems to zoom the objects on the userform
though, not the actual userform itself.

Is there a zoom funciotn for the userform window as well?

Thanks in advance

Richard

.



All times are GMT +1. The time now is 07:31 PM.

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