Userform Size

[Richard]

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]

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