Scrollbar window in Userform

[RobbieC]

Hi there, I have a userform which has a large amount of user inputs on the left hand side. There isn't much room and everything is a bit small and difficult to operate.

The right hand side of the userform has some other controls which need to be visible at all times.

Is it possible to embed my left hand side within a 'window' with a scrollbar so that I can give everything a bit more space on the left and it gives the user the ability to scroll the 'window' up and down?

If you can point me in the right direction, I'd be very grateful

Thanks

 

[My Aswer Is This]

Try putting all your controls on the left side in a Frame with a Scroll Bar
Or Use a Multipage With a Scroll Bar on the Left side with all your controls.

Put those controls you always want to see in the Top portion of your userform on the right side

Using a Multipage may be best if your using Option Buttons as if you have option buttons in a frame you can only choose One.

If you have never used a Multipage try using one. It's like have many UserForms all on the same Userform

This allows you to have hundreds on controls on the same Userform

It's like have many sheets in the same Workbook.

 

[RobbieC]

Thanks mate, I shall give that a whirl