Autofit Userform to screen

**JamesT1** · 07-12-2013, 05:17 AM

Hi Guys

Is it possible to have a userform automatically adjust and fit to a screen when the user opens it

Many thanks
JT

**Lifesigns** · 07-12-2013, 06:14 AM

Hi JT,

Would you want it to fit full screen?

**JamesT1** · 07-12-2013, 10:07 AM

Hi Lifesigns

yes,,,, I would like to expand the contents I have currently have on a form and would like to make it so the when the user opens the form it fills the screen and I can be sure they can see everything on it

Thanks

JT

**Lifesigns** · 07-12-2013, 10:19 AM

You can try the below:

Please Login or Register  to view this content.

Not a great way of doing it but it should work.

**Kyle123** · 07-12-2013, 10:30 AM

Have a look at the Form Fun download here: http://www.oaltd.co.uk/excel/

**JamesT1** · 07-15-2013, 07:23 AM

Lifesigns

This is exactly what I need many thanks for your help much appreciated

Kyle123

Thanks for the link,, looks like some interesting stuff in there,