scroll bar in userform

robfo0 · Mar 28th, 2002, 01:01 PM

hi everyone, having a bit of a problem. Ive looked in the help index and searched this board but found nothing. I need to put a vertical scroll bar in my userform because it is too long to view. I added one, but it doesnt work. Do i have to add some code to make it work? if so, what? thanks!

Juan Pablo González · Mar 28th, 2002, 01:06 PM

I think you can accomplish this in an easier fashion.

Userforms have 6 properties (If i remember correctly) that relate directly to ScrollBars.

Set the .ScrollBars property to 2
Now, set the .ScrollTop to 0 (So it will appear always at the top of the form)

and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try setting this property to 200 and see how that works. There's a more "elegant" way of finding this number, but, this works as well.

robfo0 · Mar 28th, 2002, 01:09 PM

perfect! thanks juan, i saw the properties in there, but missed the "scrollbars" option. Thanks once again!

Kris75 · Jan 27th, 2010, 07:19 AM

Still Great Advice - Thanks

Mar 28th, 2002, 01:06 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I think you can accomplish this in an easier fashion. Userforms have 6 properties (If i remember correctly) that relate directly to ScrollBars. Set the .ScrollBars property to 2 Now, set the .ScrollTop to 0 (So it will appear always at the top of the form) and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try setting this property to 200 and see how that works. There's a more "elegant" way of finding this number, but, this works as well. __________________ Regards, Juan Pablo González http://www.juanpg.com

Jan 27th, 2010, 07:19 AM	#4
Kris75 Board Regular Join Date: Jul 2009 Location: Redcar, North East England Posts: 120	Re: scroll bar in userform Still Great Advice - Thanks __________________ Kris "If you do things right, people won't be sure you've done anything at all"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 01:01 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	hi everyone, having a bit of a problem. Ive looked in the help index and searched this board but found nothing. I need to put a vertical scroll bar in my userform because it is too long to view. I added one, but it doesnt work. Do i have to add some code to make it work? if so, what? thanks!

Mar 28th, 2002, 01:09 PM	#3
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	perfect! thanks juan, i saw the properties in there, but missed the "scrollbars" option. Thanks once again!