|
发表于 2012-11-13 15:34
|
显示全部楼层
本楼为最佳答案
Private Sub UserForm_Initialize()
Dim arr, i%
'导入到窗体
With Sheets("sheet1")
If Application.Sum(.Range("J5:j9")) = 0 Then End
arr = .Range("J5:j9") '范围可能会改
End With
For i = 1 To UBound(arr)
If arr(i, 1) Like "#" And arr(i, 1) > 0 Then
Me.Controls("checkbox" & arr(i, 1)) = True
End If
Next i
End Sub
Book1c.rar
(13.96 KB, 下载次数: 3)
|
|