Excel Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top