Thank you that works for scrolling. Do you have the formula for
resizing the form to screen be proportioned to the veiwable screen?

Lmnorms1

Die_Another_Day wrote:
You also need to set the scroll height property. this can be done on
the fly like so:

userform1.scrollheight = 12321 'Random number
or if you know the farthest control down...
userform1.scrollheight = CommandButton1.Top + CommandButton1.Height

HTH

Die_Another_Day
wrote:
Hello,
I am sorry to report this had no effect.

I would be willing to try another idea.

Thank you,
lmnorms1


Die_Another_Day wrote:
click on the userform in the vba editor, then view properties. change
the "Scrollbars" properties as desired.

HTH

Die_Another_Day
wrote:
I have created a form. The form is quite large - 60 fields to fill in
(The customer wanted it that way). The form is larger than the screen
were the resolution is low on the monitor. I can have the customer
adjust the resolution and then the whole form will show up on the
screen.
I was wondering if a scroll bar can be added so the customer can move
to the lower half of the form. How do I add it in?

I tried changing the form properties but that would not allow the form
to be moved or resized.

Any ideas would be greatly appreciated.

Thank you,