Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to place check boxes in individual cells, and then to
hopefully show the count of checkboxes that have been checked in a range. So for example, i need to place checkboxes in cells G14 to G25, and show the sum of checkboxes that have been marked in Cell G26. This will be a form that is used for manual data entry, FYI. Is there code i can apply that will display a "1" or a "true/false" value in the cell containing a checkbox. (At that point, I would be able to simply perform a sum of the ones, or a countif of the cells containing "True"). Also, is there a certain way I would need to insert the checkboxes in the cells so that it will work correctly. Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
Check box - true/false - i'd like a third option n/a | Excel Discussion (Misc queries) | |||
True or False for a check box | Excel Programming | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
check box - true/false/na | Excel Discussion (Misc queries) |