simple scrollbar question

S

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
 
C

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
 
S

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
 
S

scottnshelly

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

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
 
S

scottnshelly

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

Anders Silven

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

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
 
Top