Add Userform Textbox at End User Request

[neb255]

Hi,

I am trying to create a basic userform which will start with a single row of textbox(s) for user input, and if the user has a second input they can click a button to add another row without submitting it first. I would not want to limit the number of rows the user can add before they submit.

The end goal is to build out a dynamic tier structure to which the end user decides how many tiers there are.

I just cant figure out how to get the Add Tier button to add a new row of inputs and adjust the form size accordingly.

Any help is appreciated!

Thanks in advance

 

[Norie]

Why not have the single row of textboxes but when the user clicks a button the data from them is added to a multicolumn listbox and the textboxes are cleared for the user to enter the next row of data?

You could also have buttons to allow the user to edit/delete previous rows of data.

 

[neb255]

Thanks, wasnt my first choice but works!