Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Sheet1.Range("N1") = 0
Else
Sheet1.Range("N1") = ""
End If
End Sub
Private Sub CheckBox2_Click()
If CheckBox2 = True Then
Sheet1.Range("N2") = 1
Else
Sheet1.Range("N2") = ""
End If
End Sub
Private Sub CheckBox3_Click()
If CheckBox3 = True Then
Sheet1.Range("N3") = 2
Else
Sheet1.Range("N3") = ""
End If
End Sub
Private Sub CheckBox4_Click()
If CheckBox4 = True Then
Sheet1.Range("N4") = 5
Else
Sheet1.Range("N4") = ""
End If
End Sub
For i = 1 To 30'窗体中
If Me.Controls("CheckBox" & i).Value Then Sheet1.Range("N" & i) = i
Next
或
For i = 1 To 30'工作表中
If OLEObjects("CheckBox" & i).Object Then Sheet1.Range("N" & i) = i
Next