simple scrollbar question

[scottnshelly]

I want to put a scroll bar on a userform. What do i need to do to ge
that to work? I'm sure this is simple, but i am an idiot.
Thanks

 

[crossplatform]

Open the userForm, click View menu --> ToolBox

just click on ScrollBar icon in Toolbox , then draw one in you
userform.

Double click the newly added ScrollBar, then put your code there

 

[scottnshelly]

Thanks,
I got that far. Now i need to know the code..

 

[Tom Ogilvy]

What do you want the scrollbar to do?

 

[scottnshelly]

I would like it to scroll down when i push the down button. See, on m
userform i have a multipage. on the first page, very few textboxes, o
the second page, many many boxes. i looks ridiculous when i jus
stretch it all the way to fit all of the second page's boxes to b
visible. i want the scroll bar to enable the user to scroll down t
view more boxes.
does this make sense

 

[scottnshelly]

so, no one knows how to make that little scroll bar work?
are there any sites that have instructions or anything

 

[Anders Silven]

scottnshelly,

Each Page in a MultiPage has a ScrollBars property, I think that's what you
want, rather than a ScrollBar control. Set it in the Properties Window in the
VBA Editor. That way, tall pages will have a scrollbar, while shorter pages will
display as is.

HTH
Anders Silven
Excel 2002

 

[scottnshelly]

wonderful!
That is what i was needing. now, to make it work, do i adjust th
"scroll height"

 

[Anders Silven]

wonderful!

That is what i was needing. now, to make it work, do i adjust the
"scroll height"?

Good to see that it works. I haven't used this myself but "scroll height" seems
to do the trick.

BTW, had you mentioned *multipage scroll* in your first messages, I'm sure you
would have received the answer much quicker.

Best regards,
Anders Silven