VBA how do I build reference to a userform object property from a string? [duplicate]

Question

I have a button on my userform, lets call it CommandButton2. I have code that outputs at the very end a long value of 2 to refer directly to the button lets call that long ButtonValue.

Now if I wanted to loop through a number of buttons using the long value my first thought would be to do something like CommandButton(ButtonValue).Caption = Value, which obviously doesn't work.

I can use something like string concatenation to produce a string output CommandButton2.Caption but then how do I actually get that string to reference the UserForm object?

Am I even able to do such a thing and still make use of the .Caption object property? Any help would be appreciated.

Harun24hr · Accepted Answer · 2022-07-27 10:30:55Z

2

Following should work for you. Use Controls collection to set property of an object from variable.

Private Sub CommandButton1_Click()
Dim ButtonValue As Long
    ButtonValue = 2
    Controls("CommandButton" & ButtonValue).Caption = ButtonValue
End Sub

answered Jul 27, 2022 at 10:30

Harun24hr

38.1k6 gold badges24 silver badges47 bronze badges

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

2 Comments

Drawleeh Over a year ago

Yep, Controls is what I was missing there, thank you

chris neilsen Over a year ago

You should use Me.Controls.

Collectives™ on Stack Overflow

VBA how do I build reference to a userform object property from a string? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related