Please help! Scrollbar in Userform

[bimmerman]

Can someone please help me make my vertical scrollbar work??

I have searched the forums and did what I found (making the scroll bar visible and setting the scroll height) but it doesn't do anything.

In the attached file, there is a form that is only fully visible when its height setting is set to over 1000 but then you can't navigate to it all so I want it set at 400'ish and be able to scroll to the rest.

[Trebor76]

Hi there,

Try setting the forms' ScrollBarHeight property from 4 to 800 i.e. roughly double the forms' height.

HTH

Robert

[bimmerman]

Yep, making the scrollbar height to more than the height of the form works!

Thank you very much!

[royUK]

From a design point of view wouldn't a MultiPage Control be better? You could have each section on a separate page.

[bimmerman]

Unfortunately this form is somewhat out of my control as there are certain people who are insistent on the use of this big userform instead of letting me redesign it.