Sub 批量插入复选框()
Dim RG As Range
Dim S As Shape
For Each S In ActiveSheet.Shapes
If InStr(S.Name, "Ch") > 0 Then
S.Delete
End If
Next S
For Each RG In Range("B2:B15")
ActiveSheet.CheckBoxes.Add(RG.Left, RG.Top + 5, RG.Width - 20, RG.Height - 20).Select
With Selection
.Characters.Text = "是"
.Value = xlOff
.LinkedCell = RG.Address
End With
Next RG
End Sub