Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbars in Listbox | Excel Discussion (Misc queries) | |||
question about scrollbars and embedded charts | Excel Programming | |||
ListBox Scrollbars | Excel Programming | |||
MACROs involving scrollbars | Excel Programming | |||
Getting rid of scrollbars for listbox | Excel Programming |