Help Please - Refering to TextBoxs with incremental names

[BugEyedGiraffe]

Hi there,

I have a UserForm with 50 Text Boxes that are named TextBox1, TextBox2 etc etc through TextBox50.

Is there a way I can refer to the boxes using a counter?
So I have a Integer Variable that increases by 1 based on some other code.
Can I have something like TextBox(Counter).Value or something like that?

Thank you in advance

 

[My Aswer Is This]

Yes that can be done but we need more specific details on what you want to do with these 50 textbox's

Are you going to enter values into all these textboxes and then want that data copied to you sheet?

 

[My Aswer Is This]

Here is a example of a script you can use to loop through 5 Userform Textbox's. Assuming they are all named "TextBox1" "TextBox2") etc.

The script will enter the Textbox's values into Row(2) of your Worksheet starting in column A

Private Sub CommandButton2_Click()
'Modified 5/9/18 8:30 PM EDT
    Dim i As Long
    For i = 1 To 5
        Cells(2, i).Value = Controls("Textbox" & i).Value
    Next
End Sub

 

[BugEyedGiraffe]

Thanks,

It was just how to format the reference to the text boxes so "Controls("TextBox" & i).Value" was exactly what I was looking for.

Cheers

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks,

It was just how to format the reference to the text boxes so "Controls("TextBox" & i).Value" was exactly what I was looking for.

Cheers