Thread: Userform Size
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
nath nath is offline
external usenet poster
 
Posts: 57
Default 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

.