Sub addCheckBox()
For i = 1 To 8
'MsgBox (Str(i))
ActiveSheet.CheckBoxes.Add(Cells(1, i).Left, Cells(1, i).Top, 25, 16.5).Select '在cells(i,1)处添加复选框
Selection.Characters.Text = str(i) ' 显示内容
ActiveSheet.CheckBoxes(i).Value = True '选中状态
Next
End Sub