定义一个带有变量的命令按钮的名称 [英] define a name of a commandbutton with a variable in it
问题描述
我想知道如何在userform中设置commandbutton的属性,而不是通过键入'commandbutton1'来定义它的名称,而是输入'commandbutton + number'作为名称,数字= 1,使用它就像我应该能够为数字
= 1到10 ...下一个循环并设置属性到每个命令按钮,名称为commandbutton1,commandbutton2,...,commandbutton10。
I would like to know how I can set properties of a commandbutton in a userform with defining it's name not by typing 'commandbutton1' but by typing 'commandbutton + number' as name with number = 1, using it like that i should be able to make a for number = 1 to 10 ... next loop and set properties to each commandbutton with the name commandbutton1, commandbutton2, ..., commandbutton10.
推荐答案
喜欢这样:
Dim i As Integer
For i = 1 to 10
Me.Controls(" CommandButton"& i).Caption ="我是按钮#" &安培;我是
接下来我
Dim i As Integer
For i = 1 To 10
Me.Controls("CommandButton" & i).Caption = "I'm Button #" & i
Next i
这篇关于定义一个带有变量的命令按钮的名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!