Thread
:
Scrollbars & Userforms
View Single Post
#
2
Posted to microsoft.public.excel.programming
Harald Staff
external usenet poster
Posts: 1,327
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
Reply With Quote
Harald Staff
View Public Profile
Find all posts by Harald Staff