vba - userform with scroll bar

[npmkumar]

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]

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.