VBA Userform Scrollbars - need to change their size

**leecook** · 08-07-2013, 09:17 PM

Hi, I have added some code (shown below) to my userform so when a user clicks on a command button the userform is enlarged and scrollbars appear both horizontally and vertically. This is some functionality for the visually impaired so they can zoom in and then use the scroll bars.

The problem is that they seem very small on the screen. As this is for the visually impaired I need them to look larger so they can get to them. I know that if you add a scrollbar using the toolbox you can then use the properties to set the height and width but how do I do this within the code below.

Many thanks in advance.

Please Login or Register  to view this content.

**Solus Rankin** · 08-07-2013, 09:37 PM

Any properties in the properties box can be manipulated with code if you qualify the statement so:

Please Login or Register  to view this content.

and so forth.

You can change multiple properties by using a with statement:

Please Login or Register  to view this content.

You may have to change the code if you changed the name when you placed them on the userform.

**leecook** · 08-08-2013, 05:34 PM

Hi, thanks for your reply and examples. I tried adding the code you suggested but I can't get it to work. I think the problem is that when I add the scrollbars using the commandbutton I don't know what they are called. I therefore get an error that highlights ScrollBar1 as the problem. I thought that maybe when they were added it would just name them ScrollBar1 and ScrollBar2 but that doesn't seem to be the case. Is there a way to name them when they are added and then I can use the code suggested to adjust the sizes?

**Solus Rankin** · 08-08-2013, 05:38 PM

Can you attach an your workbook as an example?

I went back over your code and I'm afraid I misunderstood? Are you using an excel userform? or you've created a userform out of a sheet?

**mikerickson** · 08-08-2013, 06:44 PM

The scroll bars that "come with" the userform are different that a ScrollBar control that you can add.
Their appearance, size and location cannot be altered much other than showing or not showing them.
If you want large, easy to see scroll bars, you'll have to use ScrollBar controls.

Xero Solus, create a UF with a command button and two textboxes and run this code, it will show you about a userform's scroll bars

Please Login or Register  to view this content.

**Solus Rankin** · 08-08-2013, 06:58 PM

@Mike

Is that to me? Or the OP?

**leecook** · 08-08-2013, 07:30 PM

I have attached an example to show you. If you click on the Start Decision Tool button you will then see the userform. At the bottom left corner of the form is a Visually Enhanced Version command button. If you click this the userform zooms in but you will see the scroll bars at the right and bottom seem really small. I need to try and make them bigger if possible.

**mikerickson** · 08-09-2013, 01:49 AM

You cannot make those scroll bars bigger. You have to add ScrollBar controls, have those controls mimic the userform's scroll bars, and make those the size you want.