i am sure this would be simple if i could understand what you want to do
What I'd like to do is to create another userform that takes a user-entered number, say '6', and then will generate another user input form with 6 entry fields that will be loaded into an array for future processing.
for a guess it you want to load a form with ? number of textboxes, you could create a form with the maximum number of possibly required boxes, set all to visible = false then just set the required number to visible = true, possibly resize the form to suit the number of boxes
where number required is the value entered in the textbox in first form
for i = 1 to numrequired
useform1.controls("textbox" & i).visible = true
there would be several methods to do like this