求助:如何用循环为控件赋值?

denniscan

有 m x n 个CheckBox排列,名称结构为 T(m)_(n) ,请问如何用两重For为每一个控件赋初始值呢?
    在线等,谢谢!

Victor_Duane

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
这是ACCESS的写法，EXCEL我不会，提供一个思路吧