Scroll Bar

[Todd Huttenstine]

I have a userform that is not big enough to put all the
form objects in it that I need. Expanding the User Form
Horizontal or Vertical is not an option. I want to be
able to have the same size Userform as it is now(because
it wont expand any further horizontally) with a horizontal
scroll bar where I can move the scroll bar to see more
form objects (Labels, textboxes, Comboboxes, etc...).

Thanx

Todd Huttenstine

 

[Robin Hammond]

Todd,

I guess that is possible, but have you considered a multi page control
instead. It would be a lot cleaner.

Robin Hammond
www.enhanceddatasystems.com

 

[Rob van Gelder]

Todd,

Set the Userform ScrollBars property to fmScrollBarsHorizontal and the
ScrollWidth property to something large, say, 6000.