引用Excel Userform控件名字符串值(VBA) [英] Referencing Excel Userform Control Name Value From String (VBA)
问题描述
通常,当在Excel VBA中引用userform控件值时,我将输入一些效果,例如radiobutton.value
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.
例如,我可能想要引用ctradiobutton.value一次,和etradiobutton.value接下来,这些控件已经存在于表单上,我只想从当前迭代中创建的字符串引用不同的控件名称。
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.
推荐答案
像这样(其中 Me
是UserForm)
Like this (where Me
is the UserForm)
Me.Controls("TextBox1").Value
这篇关于引用Excel Userform控件名字符串值(VBA)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!