Design UserForm Beyond Bottom of Screen RRS feed

  • Question

  • I'm a neophyte VBA user, designing a simple form for work. It will be slightly longer than the user's screen is high. I've figured out how to enable scroll bars when it's used.  My problem is this:  As I lay out the form using VS Express, I can't extend the height far enough (and then scroll down to complete the form design).

    My book describes the 'Autoscroll'-related properties of the window, but they describe how it will behave with the user.  I'm trying to make it longer/higher as the programmer/designer.  I've tried pulling down the bottom edge of the form, but reach a maximum and VS Express won't let me pull it down any further.

    Where do I go to allow me to make it longer/higher?

    Thanks in advance!

    Friday, April 18, 2014 4:16 AM

All replies

  • If the userform is that large, it would probably make more sense to break it up into a suitable number of smaller pages.

    Graham Mayor - Word MVP

    Friday, April 18, 2014 2:25 PM