Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom size (page size) missing in excel 2003 | Setting up and Configuration of Excel | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming |