Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Checkboxes
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Remove outdated checkboxes from Excel Pivot Table field pulldown? | Excel Discussion (Misc queries) | |||
excel viewer | Setting up and Configuration of Excel |