Scrollbar window in Userform

RobbieC

Active Member
Joined
Dec 14, 2016
Messages
376
Office Version
  1. 2010
Platform
  1. Windows
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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top