Scrollbar on userform in design mode

[harley]

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

 

[Jim Cone]

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" <[email protected]>
wrote in message
news:[email protected]...