Looping through text boxes on a user form

[Joe4]

On a user form, I have 30 text boxes named txtFund1 through txtFund30. In VBA, I am trying to access these boxes to initialize them, and update values on my Excel spreadsheet with these values.

I can to do all this pretty easily by writing a line for each inidividual text box. However, I want to be more efficient and use a loop. However, I can not get it to work. Here is my code to initialize the values, that isn't working:

    Dim i As Integer
    Dim MyTextBox
    For i = 1 To 30
        MyTextBox = txtFund & i
        MyTextBox.Value = ""
    Next i

What do I need to do to be able to loop through all 30 text boxes? Keep in mind that there are also other text boxes on my form, so I can't just through all text boxes on the form.

[Andrew Poulsom]

Try:

Dim i As Integer 
For i = 1 To 30 
    Controls("txtFund" & i).Value = "" 
Next i

[Joe4]

Andrew,

Thank you!!! That was just what I needed.