How to set up a userform with verticle scroll bars.

[j_Southern]

I need to design a user form that will have three columns of text boxes, where the column length will only be known at run time. It could be that there will be 20 or 30 columns, but it could be as few as 1.
The data to populate the form will be a 3Col by x Row array. The purpose of using a userform is to allow the user to select one row, so as well as the columns of textboxes there would, perhaps be an OptionButton. I can see that scroll bars will be useful but I don,t know how to use them. Can anybody help please.
John

[LJMetzger]

Hi,

In the UserForm Properties:
a. Change the ScrollBars Property to 2 - fmScrollBarsVertical.
b. Change the ScrollHeight Property to a number larger than the UserForm Height.
c. Optionally changes the ScrollTop Property.

These items can be changed using VBA if you need to change values at runtime to remove the ScrollBars or to make the scroll height larger or smaller.

Lewis