求助:如何用循环为控件赋值?
有 m x n 个CheckBox排列,名称结构为 T(m)_(n) ,请问如何用两重For为每一个控件赋初始值呢?
答:
Sub setIntvalue(frm As Form, m As Integer, n As Integer, Optional x As Boolean = True)
Dim ctl As String
Dim i As Integer
Dim j As Integer
For i = 1 To m
For j = 1 To n
ctl = "T(" & i & ")_(" & j & ")"
frm.Controls(ctl).Value = x
Debug.Print ctl, x
Next
Next
End Sub