Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / March 2005

Tip: Looking for answers? Try searching our database.

Including a Vertical Scrollbar in a VBA Userform

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LizW - 07 Mar 2005 20:17 GMT
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
Jonathan West - 10 Mar 2005 12:35 GMT
> After creating a userform, I wanted to include a vertical scrollbar
> because
[quoted text clipped - 6 lines]
>
> Any ideas would be appreciated

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.

Signature

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


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.