View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Scrollbars & Userforms

Hi Keith

Try setting the ScrollHeight property to a pixel number greater than the
form's height.

HTH. Best wishes Harald

"Keith S" <Keith skrev i melding
...
I am new to programming in VB, so I will try to explain this as clearly as
possible.

I created a userform using Visual Basic, but the form is longer than the
size of our monitors. I changed the following properties on the userform:

KeepScrollBarsVisible - set to fmScrollBarsVertical
ScrollBars - set to fmScrollBarsVertical

When I run my macro and the userform appears, I can see the vertical
scrollbar but I cannot actually scroll up and down the screen; thus I am

not
able to see the entire form and all of the text boxes, radio buttons,

etc.,
which I created.

Can someone tell me what I need to do so I can scroll up and down this

form?

Thanks,
Keith