ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scrollbars & Userforms (https://www.excelbanter.com/excel-programming/321272-scrollbars-userforms.html)

Keith S

Scrollbars & Userforms
 
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

Harald Staff

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




Keith

Scrollbars & Userforms
 
Harald -

I tried just about everything else except for that - makes perfect sense!
Thanks very much.

Keith

"Harald Staff" wrote:

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






All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com