Scale userform

Question

Hello all,

I developed a userform for office use, and it has been working fine.  Now however, the excel workbook is also being used by sales people using laptops (14" screens) and they are complaining that the userforms do not fit on the screen and that they cannot access the command buttons that I placed at the bottom of the form.

Is there a way to auto scale a form to fit on whatever size screen the user has?

Thank you,

QuestionBoy

Answer 1

Autoscaling a userform is problematic - it's difficult to predict whether the layout will look good and whether text will remain readable (if you shrink text boxes/labels and keep the font size the same, the text may not fit any more, but if you reduce the font size, it may become too small to read).

The general recommendation is to design forms for the lowest resolution that you want to support. They should then still be useable in higher resolutions.

Answer 2

It's best to ask the users - 14" could mean 1280 x 800 or 1440 x 900, or a different resolution.

Take the smallest you find it reasonable to support - you probably don't want to support 800 x 600 any more, perhaps not even 1024 x 768, sizes that used to be common a few years ago.

Then right-click your desktop in Windows and look up the screen resolution. That will give you an idea which part of the screen you can use.

Answer 3

Ok, so basically redesign my existing forms, ****!

This brings up a sub-question. I do not have a 14" laptop, so how do I know the permittable size to design for? Is there a way based on their resolution to know the maximum height and width to design a userform around?

QuestionBoy