Thread: Scroll Bar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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