PDA

View Full Version : vba - userform with scroll bar



npmkumar
08-31-2006, 10:34 PM
Hai,

I want to create a user form with scroll bar, The form contains 50 list box within the scorll bar. So i want to scorll the list boxs.

Pls help me.

Thanks
Kumar.N.P.M

Jan Karel Pieterse
08-31-2006, 11:25 PM
Insert a frame on the form, set its scrollbar property to whichever you like and insert your boxes in there.

I'd advise you however, to consider a different approach, such as a multipage. 50 controls on a single form is very overwhelming. Split them over a couple of steps and put those on their own page of a multipage control.