Looping through text boxes on a user form

Try:

Andrew,

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

Andrew Poulsom said:

Try:

Code:

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

Click to expand...

I am wondering about a step that would be before this. I am creating my textboxes in a loop but believe I am not naming them properly because the code above does not work to fill them however if I put in text boxes by hand it does.

Here is what I have tried for creating the textboxes

Sub Add_Stages()
Dim txtB2 As Control
Dim txtB1 As Control
Dim lbl1 As Control
Dim lbl2 As Control
Dim i As Integer
i = 1

For i = 1 To fsrform.Stages.Value

Set lbl1 = fsrform.MultiPage1.Pages("StagesTab").Controls.Add("Forms.Label.1")

With lbl1
.Name = "Stagelbl" & i
.Caption = "Stage " & i & " name:"
.Height = 16
.Width = 80
.Left = 20
.Top = 30 + (i * 30)
End With

Set txtB1 = fsrform.MultiPage1.Pages("StagesTab").Controls.Add("Forms.TextBox.1")

With txtB1
.Name = "Stage" & i
.Height = 16
.Width = 220
.Left = 110
.Top = 30 + (i * 30)
End With

Set lbl2 = fsrform.MultiPage1.Pages("StagesTab").Controls.Add("Forms.Label.1")

With lbl2
.Name = "Dayslbl" & i
.Caption = "Days in Stage " & i & ":"
.Height = 16
.Width = 80
.Left = 340
.Top = 30 + (i * 30)
End With

Set txtB2 = fsrform.MultiPage1.Pages("StagesTab").Controls.Add("Forms.TextBox.1")

With txtB2
.Name = "Days" & i
.Height = 16
.Width = 40
.Left = 430
.Top = 30 + (i * 30)
End With

Next

End Sub

How could i select specific text boxes from multiple text boxes in excel userform vba?

Dear Sir,
How could i select specific text boxes from multiple text boxes in excel userform vba?

please help me in this regards.

Regards.