Referencing the content of a variable as a variable irself

[patupatu]

Hello. In have a list of variables named Button1 Button2 Button3
In a For loop, can I reference the buttons asÑ
VarButton="Button"
For I = 1 to 3
Button = VarButton & I ´ Button value would be "Button1" an so on
Next I

Thank you

 

[mjbeam]

Not sure exactly what you are wanting to do, but you could access all The objects on your userform whose names start with Button like this:

VarButton = "Button"
For Each tObj In UserForm1.Controls
    If Left(tObj.Name, 6) = "Button" Then
        tObj.Caption = VarButton
    End If
Next

 

[patupatu]

Actually, I have a series of buttons all names SNx where x goes from 1 to 13, ie SN1, SN2, SN3. Eventually have to change the caption on each button depending on the value of a variable (x from one to 13) Instead of using a Select Case premitive, one case for each posible value of x, I might be able to use a variable Button = "SN" and concatenate with x thus producing SN1, SN2, SN3 and so on.

Something like this

For x=1 to 13
With Button & x ' meaning SN1, SN2, SN3, .....
set ot instructions
next x

Not sure exactly what you are wanting to do, but you could access all The objects on your userform whose names start with Button like this:

VarButton = "Button"
For Each tObj In UserForm1.Controls
    If Left(tObj.Name, 6) = "Button" Then
        tObj.Caption = VarButton
    End If
Next

 

[patupatu]

By the way, thank you for your time.

Not sure exactly what you are wanting to do, but you could access all The objects on your userform whose names start with Button like this:

VarButton = "Button"
For Each tObj In UserForm1.Controls
    If Left(tObj.Name, 6) = "Button" Then
        tObj.Caption = VarButton
    End If
Next

 

[mjbeam]

Are the buttons on a worksheet or on a userform?

 

[patupatu]

Userform

are the buttons on a worksheet or on a userform?

 

[mjbeam]

For x=1 to 13
  UserForm1.Controls("SN" & x).Caption = "SN" & x
next x