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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

What do you want the scrollbar to do?

--
Regards,
Tom Ogilvy


"scottnshelly " wrote in
message ...
Thanks,
I got that far. Now i need to know the code...


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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 " skrev i
meddelandet ...
I would like it to scroll down when i push the down button. See, on my
userform i have a multipage. on the first page, very few textboxes, on
the second page, many many boxes. i looks ridiculous when i just
stretch it all the way to fit all of the second page's boxes to be
visible. i want the scroll bar to enable the user to scroll down to
view more boxes.
does this make sense?


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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