Reading data from many TextBoxes in UserForm

In this example, I filled an array for textbox and combobox controls. If you have other textbox controls that you don't want to add, then use the Tag property and check it or:

Please Login or Register  to view this content.

TextBox would be your prefix name and 7 is the length of the prefix. This If goes after the Case "TextBox" below.

Put this into the top of a Module:

Please Login or Register  to view this content.

In the Userform:

Please Login or Register  to view this content.

Your example seems to be a bit too complicated for me ;/ and it does not work.
Could you attach your example file?

I want to ask you moreover, how to such a thing :

I declare a variable (eg. i)
I create a loop

For i=1 to 5
///// and here I dont know how to type a name of TextBox+ variable i
(for example i=1 then the name is TextBox1)

Thanks for your time, Adam

Sorry, the first method was to make a control array.

To use these examples, add Userform1, 15 Textbox and 2 commandbutton controls. I show 2 methods to do it with the code below. Doubleclick Userform1 and add this code.

Fill the textboxes and then push one of the 2 buttons to show the results in a MsgBox.

Please Login or Register  to view this content.

Afff.... Ive done it. Thank you for your help, Mates

Thanks again, Adam