Excel Checkboxes
A response from Bob Phillips to an early posting today asking a similar
question. This will count check boxes ticked.
Dim chk As CheckBox
Dim c As Long
For Each chk In ActiveSheet.Checkboxes
If chk.Value = Then c = c + 1
Next chk
MsgBox c
Bob's alternative sggestion was:
Use checkboxes and link that to cells (D1,D2 etc.) and then just use
=COUNTIF(D1:D10,TRUE)
HTH
"nir020" wrote:
I have an excel spreadsheet that contains a number of check boxes in it, is
it possible to write some code which would allow you to determine if the
check box had been ticked or not.
The reason I am asking is that tthere are a large number of these checkboxes
and I would like to incorporate into a macro that could read it all off
instantly
|