Variable Controls

**mojo249** · 09-10-2011, 10:06 AM

Hi

What's the syntax for referring to a variable control name?

I have a userform with 20 textboxes (txtAmount1, txtAmount2 etc) and I want to loop through each of those controls, so I want to do something like:

For varRow = 1 To 20
    Me.txtAmount" & varRow & ".text = "whatever"
Next varRow

I know I can loop through all controls on the form (and restrict based on control name) but I want to be able to do something similar to the above for other reasons: I have another column of textboxes (txtSupplier1, txtSupplier2 etc) and if I update txtSupplier2 then I want to update the corresponding txtAmount2.

Any help is appreciated.

Dion

**mrice** · 09-10-2011, 10:17 AM

Something like..

For X = 1 To 3
    If UserForm1.Controls(X).Name Like "TextBox*" Then
        UserForm1.Controls(X).Text = "Whatever"
End If
Next X

**barryleajo** · 09-10-2011, 10:26 AM

Try

Private Sub UserForm_Click()
Dim varRow As Long

    For varRow = 1 To 20
        Me.Controls("txtAmount" & varRow).Text = "whatever"
    Next varRow
    
End Sub