![]() |
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 |
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