Including a Vertical Scrollbar in a VBA Userform

L

LizW

After creating a userform, I wanted to include a vertical scrollbar because
it is longer than the screen shows. I put in the value of the height of the
page in Scrollbar Height as 850 (it won't take anything less) and then I
tried setting scroll top but it only allowed me about 18.75 which is very
little room to scroll and doesn't allow the user to really scroll the page.

Any ideas would be appreciated
 
J

Jonathan West

LizW said:
After creating a userform, I wanted to include a vertical scrollbar
because
it is longer than the screen shows. I put in the value of the height of
the
page in Scrollbar Height as 850 (it won't take anything less) and then I
tried setting scroll top but it only allowed me about 18.75 which is very
little room to scroll and doesn't allow the user to really scroll the
page.

Any ideas would be appreciated
Click to expand...

Hi Liz,

Set the ScrollHeight of the UserForm to a larger value than Height, set the
ScrollBars property to fmScrollBarsVertical. You don't need to put a
separate ScrollBar control on the UserForm.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
Top