'窗体复选框
Sub test1()
Dim x As Shape
For Each x In Me.Shapes
If Me.Shapes(x.Name).LinkFormat = 1 Then
Debug.Print x.Name, x.TopLeftCell.Address
End If
Next
End Sub
'AcitveX复选框
Sub test2()
Dim x As OLEObject
For Each x In Me.OLEObjects
If x.Object.Value Then
Debug.Print x.Name, x.TopLeftCell.Address
End If
Next
End Sub
'窗体复选框
Sub test1()
Dim x As Shape
For Each x In Me.Shapes
If Me.Shapes(x.Name).LinkFormat = 1 Then
Debug.Print x.Name, x.TopLeftCell.Address
End If
Next
End Sub
'AcitveX复选框
Sub test2()
Dim x As OLEObject
For Each x In Me.OLEObjects
If x.Object.Value Then
Debug.Print x.Name, x.TopLeftCell.Address
End If
Next
End Sub