Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form height and scroll
Hi
I have this very heigh form, and want to make a size to it and then have scroll, but no matter what i do the scroll dosn't work and when i set my height to full height at the form so the form can't be there on the screen, then my scroll dosn't work, and i cant see the lower part off my form can someone help here? Alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form height and scroll
Set the UserForm's ScrollBars property to 2-frmScrollBarsVertical AND set
its ScrollHeight property to a number that is **larger** than its Height property... doing this will show you the "thumb button" on the vertical scrollbar which you can use at design time to place your components on the form in the "off screen" locations. -- Rick (MVP - Excel) "alvin Kuiper" wrote in message ... Hi I have this very heigh form, and want to make a size to it and then have scroll, but no matter what i do the scroll dosn't work and when i set my height to full height at the form so the form can't be there on the screen, then my scroll dosn't work, and i cant see the lower part off my form can someone help here? Alvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form height and scroll
Thanks
alvin "Rick Rothstein" skrev: Set the UserForm's ScrollBars property to 2-frmScrollBarsVertical AND set its ScrollHeight property to a number that is **larger** than its Height property... doing this will show you the "thumb button" on the vertical scrollbar which you can use at design time to place your components on the form in the "off screen" locations. -- Rick (MVP - Excel) "alvin Kuiper" wrote in message ... Hi I have this very heigh form, and want to make a size to it and then have scroll, but no matter what i do the scroll dosn't work and when i set my height to full height at the form so the form can't be there on the screen, then my scroll dosn't work, and i cant see the lower part off my form can someone help here? Alvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I autofit row height to adjust to new text on Excel form? | Excel Discussion (Misc queries) | |||
Is there a max height for the user form in Excel | Excel Programming | |||
Zoom and Scroll Form | Excel Programming | |||
Scroll name in about-form for credit | Excel Programming | |||
Form titlebar height | Excel Programming |