Form height and scroll

  • Thread starter Thread starter alvin Kuiper
  • Start date Start date
A

alvin Kuiper

Hi
I have this very heigh form, and want to make a size to it and then have
scroll, but no matter what i do the scroll dosn't work and when i set my
height to full height at the form so the form can't be there on the screen,
then my scroll dosn't work, and i cant see the lower part off my form
can someone help here?

Alvin
 
Set the UserForm's ScrollBars property to 2-frmScrollBarsVertical AND set
its ScrollHeight property to a number that is **larger** than its Height
property... doing this will show you the "thumb button" on the vertical
scrollbar which you can use at design time to place your components on the
form in the "off screen" locations.
 
Thanks
alvin

"Rick Rothstein" skrev:
Set the UserForm's ScrollBars property to 2-frmScrollBarsVertical AND set
its ScrollHeight property to a number that is **larger** than its Height
property... doing this will show you the "thumb button" on the vertical
scrollbar which you can use at design time to place your components on the
form in the "off screen" locations.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long User Form Question. 2
Position Userform In Cells Portion of Excel Only 1
Vertical scroll bar in a MultiPage 1
Listbox 1
ActiveX ProgressBar - Scrolling Error disables color update 1
Scroll the Scoreboard 3
VBA and Internet Explorer 9
Excel VB ListBox 'Height' Problem 3

Back
Top