![]() |
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 |
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 |
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