定义: dim Frame1 as new colleage dim Frame2 as new colleage ... Frame1.add textbox1 Frame1.add textbox2 ... Frame2.add textboxX Frame1(1)="***"
每个Frame中的text控件做一个text控件数组不行吗?
有很多个frame控件? 我记得窗体上最多不超过339个控件。 你嫌麻烦,可以像如下添加到各个数组里,再对数组元素操作。 Private Sub Command1_Click() Dim a() As TextBox Dim s As Control Dim i As Integer
ReDim a(0) As TextBox For Each s In Controls If s.Container Is Frame1 And TypeName(s) = "TextBox" Then If i = 0 Then Set a(0) = s Else ReDim Preserve a(i) Set a(i) = s End If
i = i + 1 End If Next
For i = 0 To UBound(a) Debug.Print a(i).Name 'a(i).Text = i Next End Sub
dim Frame1 as new colleage
dim Frame2 as new colleage
... Frame1.add textbox1
Frame1.add textbox2
...
Frame2.add textboxX
Frame1(1)="***"
你嫌麻烦,可以像如下添加到各个数组里,再对数组元素操作。
Private Sub Command1_Click()
Dim a() As TextBox
Dim s As Control
Dim i As Integer
ReDim a(0) As TextBox
For Each s In Controls
If s.Container Is Frame1 And TypeName(s) = "TextBox" Then
If i = 0 Then
Set a(0) = s
Else
ReDim Preserve a(i)
Set a(i) = s
End If
i = i + 1
End If
Next
For i = 0 To UBound(a)
Debug.Print a(i).Name
'a(i).Text = i
Next
End Sub
frame1的textbox1(0);textbox1(1);textbox1(2)……
frame2的textbox2(0);textbox2(1);textbox2(2)……
…………