excel vba, assigning values to variables with similar names using for next loop

Question

Brand new to stackoverflow and am also quite new to programming. I am very grateful for this incredible resource. Thank you!
I have 30 TextBoxes on my Userform. TextBox1 TextBox2......TextBox30. I would like to assign values to all of them quickly using a For Next Loop. Just not too sure how. Example:

For X=1 to 30
   TextBox & X.Value ="Hello"
Next X

Thank you in advance for any help.

Davesexcel · Accepted Answer · 2016-01-06 08:52:54Z

1

This should do it.

Private Sub UserForm_Initialize()
    For x = 1 To 30
        Controls("Textbox" & x).Value = "Hello " & x
    Next x
End Sub

answered Jan 6, 2016 at 8:52

Davesexcel

6,9922 gold badges31 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Onesong Over a year ago

Thank you so much for your help. This certainly worked. Have a great day.

Davesexcel Over a year ago

Mark it as the answer

sndyuk · Accepted Answer · 2016-01-06 09:47:06Z

0

How about this:

For x = 1 To 30
  Sheets(1).Shapes("textbox " & x).TextFrame.Characters.Text = "Hello"
Next x

answered Jan 6, 2016 at 9:47

sndyuk

2,7902 gold badges27 silver badges32 bronze badges

1 Comment

Davesexcel Over a year ago

The textboxes are in a userform, not on the worksheet

Collectives™ on Stack Overflow

excel vba, assigning values to variables with similar names using for next loop

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related