PC Review


Reply
Thread Tools Rate Thread

Code to display a true or false value in the cell containing a check box

 
 
Dave K
Guest
Posts: n/a
 
      26th Aug 2010
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.


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      26th Aug 2010
Check your other post.

On 08/26/2010 12:20, Dave K wrote:
> 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.
>
>


--
Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
True or False for a check box Doug Microsoft Excel Programming 4 16th Dec 2009 09:06 PM
VB help with True/False Check box dsc2bjn Microsoft Access 3 11th Dec 2007 12:26 AM
Check if Conditional Format is True or False / Check cell Color =?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?= Microsoft Excel Worksheet Functions 5 29th Jun 2007 11:12 AM
check box - true/false/na =?Utf-8?B?S2VsbHkgMXN0?= Microsoft Excel Misc 4 13th Jul 2006 12:44 PM
Check box to indicate True or False =?Utf-8?B?RC4gR3JlZW4=?= Microsoft Access Forms 0 21st Feb 2005 06:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:57 PM.