Scroll Bar
 

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

Scroll Bar
 

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

"Todd Huttenstine" wrote in message
...
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

Scroll Bar
 

Todd,

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Todd Huttenstine" wrote in message
...
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