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

vbavariables

提问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