Scroll a Userform

[Ziggy12]

Oh such a tangled web....
I've created a really useful userform that suits all the users except the one with really low screen resolution. I don't want to change the size of the form the bottom of which is not visible on the 640X480 screen

How do I put scrollbars on a userform so the user can scroll down to the command buttons?


Or any other ideas.

 

[Ziggy12]

Found the answer on http://msdn.microsoft.com/default.asp

UserForm1.ScrollBars = fmScrollBarsBoth
UserForm1.KeepScrollBarsVisible = fmScrollBarsNone

UserForm1.ScrollHeight = 2 * UserForm1.Height
UserForm1.ScrollWidth = 2 * UserForm1.Width

'Set ScrollHeight, ScrollWidth before setting ScrollLeft, ScrollTop
UserForm1.ScrollLeft = 0 'UserForm1.Width / 2
UserForm1.ScrollTop = 0 'UserForm1.Height / 2