While working with userforms, you sometimes end up with more controls than could fit on the screen. Altough you should try to keep the forms simple and uncluttered, well, there are circumstances where this is not possible.
Consider a form with 3 frames, like the following.
As you can see, Frame3 is not completely visible. One possible solution is to use the Userform’s Scrollbars. The first thing that needs to be done is change the properites of the form, to display the vertical scrollbar, so change the
If you run the userform again, the scrollbar will appear, but it won’t work yet. That is because we still need to tell it how much we need to scroll. To do this, we change the
ScrollWidthproperties. This form has a
200.25, so we need to set the
ScrollHeightproperty to a value larger than this. Setting it to
215.25works fine, as you can see in the image.