View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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