Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$3" Then
Call test2
Shapes(VBA.Replace([e3], "Level ", "")).LinkFormat = True
End If
End Sub
'取消勾选
Sub test2()
Dim i
For i = 1 To Shapes.Count
If Shapes(i).Type = 8 Then Shapes(i).LinkFormat = False
Next i
End Sub
复选框自动打勾2.rar
(15.4 KB, 下载次数: 27)