vba Visual Basic - 变量名自动递增/循环
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/13326871/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 18:26:39 来源:igfitidea点击:
Visual Basic - variable names auto increment / loop
提问by Cenas
Is there a way when I want to do this:
当我想这样做时有没有办法:
textbox1.text = x + i
textbox2.text = x + i
textbox3.text = x + i
To do for example like this?
例如这样做?
for l = 0 to 2
textbox(l) = x + i
next
回答by Doug Glancy
Assuming these controls are inside a userform, do something like:
假设这些控件位于用户窗体中,请执行以下操作:
Private Sub FillTextboxes()
Dim i As Long
Dim x As Long
x = 10
For i = 0 To 2
Me.Controls("textbox" & i + 1).Text = x + i
Next i
End Sub