Scrollbar settings in a form

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
682
Office Version
  1. 365
Platform
  1. Windows
Hello,

I am trying to setup a scroll bar for a form i have created.
I have looked on several websites but, I am having a few issues with the VB. I only need a scroll bar to appear down the right hand side of a form.

Any help would be appreciated.

Thanks
Gavin

:confused:
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Rasm

Well-known Member
Joined
Feb 9, 2011
Messages
500
ok - Select it from the toolbox and paste it into your userform - not sure what the problem is!!! - just make it taller than it is wider - hmmm - what is the problem.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
Gavin

What's the purpose of the scrollbar and what have you tried so far?
 

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
682
Office Version
  1. 365
Platform
  1. Windows
Gavin

What's the purpose of the scrollbar
and what have you tried so far?
The scroll bar is to move up and down a form i have created. I have added a scroll bar to the form. I have tried to amend the scroll bar in the properties, but the square in the bar just flashes.

Any help will be appreciated.

Gavin
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
Gavin

How did you add the scrollbar?

If it's a scrollbar control it won't do anything unless you tell it.

By the way, I'm still wondering why you need a scrollbar for the form - do you have a large amount of controls?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,147
Messages
5,835,667
Members
430,373
Latest member
swartzfeger

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
Top