VBA Programming for Excel 2010 - V4.11 - UserForm GUI - Scroll Bar Properties (Horizontal Vertical)

preview_player
Показать описание
VBA Programming for Excel 2010 - V4.11 - UserForm GUI - Scroll Bar Properties (Horizontal Vertical)

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.
Рекомендации по теме
Комментарии
Автор

Great video, very informative. Just a little comment: From the instructions you'd get the impression that you have to add the extra code yourself in the "initialize" section so as to make the scrollbars visible when you actually show/play the Userform. This is not necessary. The reason why the they didn't show the first time you played the Userform is because you haven't set any value for the scrollheight in the userform properties before (which in the initialize code you do set to 3 times the frame height). The scrollheight is the actual height of the content of the whole Userform, whereas the usual height is just the height of the Userform itself. Of course, as long as scrollheight < height, there is no extra space to show when scrolling and hence the scrollbars won't show.

PublicStaticVD
Автор

Thanks man. It's a little thing thats been bugging. I've just set up my first userform and I've been concentrating on the meat of the userform code functioning properly. Getting this scrolling functioning is cherry on top. :)

AW_
Автор

Hi Alex. Nice tute. Any idea why this may not work on a Mac version?

electronicinkYT
Автор

How do you use the mousewheel to command the scrollbars?

bourleauxP
Автор

Can you have a scroll bar which scrolls down an individual multipage within a form?

EASYTIGER
Автор

Thanks a lot. God bless you. this helped me a lot.

JoseGonzalez-yimk
Автор

Great, but does not work I keep getting a error - Scrollbars property not valid.  use a number 0 to 3.  Very new at this stuff.  I know little things mean a lot. I Guess I don't know where to get the scrollbar property.  Click on user form go to properties scroll down to scrollbars and I have a value of 0 in all. Thanks for all your tutorials

randipeters
Автор

Think I Got it.  Second Row of code was not spelled right.  Thanks again!

randipeters