Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar on userform in design mode
I have a long form with a scrollbar that works fine at run time. I
need to add more controls to the form. How do I scroll the form while in design mode? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrollbar on userform in design mode
Note the displayed height of the form (say 650) in the adjacent properties window.
Drab the bottom corner of form down until you get to the height that will hold all the controls. Add the additional controls. In the Sub UserForm_Initialize() event add code that specifies the noted height... Me.Height = 650 -- Jim Cone Portland, Oregon USA http://www.contextures.com/excel-sort-addin.html Independent review of Special Sort excel add-in (30 ways to sort) "harley" wrote in message ... I have a long form with a scrollbar that works fine at run time. I need to add more controls to the form. How do I scroll the form while in design mode? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod | Excel Programming | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
Nudging controls in UserForm Design Mode | Excel Programming | |||
FullScreen Mode Horizontal ScrollBar Missing | Excel Programming | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |