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 |
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 |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com