Referencing Excel Userform Control Name Value From String (VBA)

Question

Typically when referencing a userform control value in Excel VBA I would enter something to the effect of radiobutton.value

However, I want to be able to use a string as the name of the user control. The idea behind this would be to dynamically be able to generate the control name and reference a value from it.

For example I may want to reference ctradiobutton.value one time, and etradiobutton.value the next, these controls already exist on the form, I just want to reference a different name of the control from a string created on the current iteration.

I'm pretty sure that you can't change the code name of a control once it's on a userform — SWa
– SWa, Commented Jun 6, 2014 at 14:06
You'll get a runtime error 382, it's not possible to set the control's .Name property at run-time. Perhaps you can use another property like .Caption to control your process flow. — David Zemens
– David Zemens, Commented Jun 6, 2014 at 14:09
@Kyle I think I may have been unclear, I am not trying to change the control name on the form, but rather get the value from it in my code — Thomas
– Thomas, Commented Jun 6, 2014 at 14:09

SWa · Accepted Answer · 2014-06-06 14:10:51Z

15

Like this (where Me is the UserForm)

Me.Controls("TextBox1").Value

answered Jun 6, 2014 at 14:10

SWa

4,36325 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Referencing Excel Userform Control Name Value From String (VBA)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related