userform testbox to create number of textbox to another userform

Hi Experts!

I am creating a form where there will be multiple userforms. So I have "userform1", textbox1 is where I'll put a number, say "10" for example, is it possible to get to "userform2" and have 10 textboxes? and if "5" is entered from "userform1", 5 textboxes will be created in "userform2"?

Hi Markus,

The following code will add textbox(s) to a second userform from the number entered in a textbox on the first userform. The code assumes the following but you can change them:

FIRST USERFORM:
Name: arbitrary
one textbox name: TextBox1
one commandbutton name: CommandButton1

SECOND USERFORM:
Name: UserForm2
Can include any objects you like except textboxes named "TextBox1, TextBox2, etc."

Please Login or Register  to view this content.

You can change the parameters (height, width, left, top, value, naming convention, etc). Remember that the textboxes are created at runtime and will not be prest after the code is finished running. Therefore, you want to initiate Userform2 in the code from commandButton1 on UserForm1 and continue running your code from the second userform in a continuous flow.

If possible, a better approach is to have all the textboxes with .visible = FALSE on userform2 at design time and set their .visibility to TRUE as needed.

HTH,
Maud

what do you mean?

I had verbiage that was being picked up as an HTML tag. I removed it and it enabled me to post....see above.

Maud

thank you so much Maudibe! Your code worked like a charm. One more thing, is there a way that userform2 can have like 40 textboxes and have 4 columns to fit them (10 textbox per column).

Markus,

Here is the code revised so that multiple column of textboxes can be created. Like the previous code Userform1 must have a textbox called Textbox1 and a button called CommandButton1. Userform2 can be blank or have any objects you please as long as they are not named Textbox1, TextBox2, etc..

**NEW**
when you launch Userform1, in Textbox1 enter the number of total textboxes, a "/", and the number of columns (eg. 34/4) which yield 34 total textboxes in 4 columns. The code auto-arranges the remainder of the textboxes. The height and width of the form are automatically calculated using the number of columns, width, and height of the textboxes.

HTH,
Maud

Add Textboxes.png

Please Login or Register  to view this content.

I totally appreciate your time for helping me on this, it works perfectly! now I just have to figure out if it's possible to have all the entries from all my userforms be transferred to just one worksheet.

This will do it:

Please Login or Register  to view this content.