Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod Craig Excel Programming 0 March 16th 05 04:53 PM
Combo Box goes to edit mode even if design mode is in OFF position Chas Excel Discussion (Misc queries) 0 January 7th 05 07:21 PM
Nudging controls in UserForm Design Mode Rick Brown Excel Programming 1 September 21st 04 11:47 PM
FullScreen Mode Horizontal ScrollBar Missing GreenBoy Excel Programming 3 September 7th 04 07:13 PM
Enter Excel Design Mode and Exit Design Mode Bill Lunney Excel Programming 0 August 4th 03 07:48 AM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"