Excel Checkboxes

[Guest]

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

 

[Guest]

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(D110,TRUE)

HTH