Office中国论坛/Access中国论坛

标题: 求助:如何用循环为控件赋值? [打印本页]

作者: denniscan 时间: 2007-11-21 10:34
标题: 求助:如何用循环为控件赋值?
有 m x n 个CheckBox排列,名称结构为 T(m)_(n) ,请问如何用两重For为每一个控件赋初始值呢?
在线等,谢谢!

作者: Victor_Duane 时间: 2007-11-21 22:49
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我不会，提供一个思路吧

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)