Userform Scroll Bars

[mattyads05]

Hi.

I have looked for a thread that would solve the problem I am having but with no luck.

I have created a Userform that will be used on a number of different PC's and laptops.

The form itself seems to be working fine but on some screens the form does not fit and users cannot move the form in such a way that they can see all fields and/or buttons that need to be used.

I have played around a little with scroll bars and also tried some coding where the user could scroll with their mouse, all to no avail.

Can anyone suggest a workaround?

I have set the form so that it appears when opening the document and the Excel application is hidden, so just the userform is on display.

Thanks in advance

 

[RoryA]

If you set the scrollheight and scrollwidth properties of the form to your current Height/Width values, then reduce the latter two to something that will fit on all screens, and finally set the form to show scrollbars, your users will be able to scroll to use the whole form.