Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Code to display a true or false value in the cell containing a check box

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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 420
Default Code to display a true or false value in the cell containinga check box

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display TRUE / FALSE Instead Of 1 / 0 ExcelUser123 Excel Discussion (Misc queries) 12 April 3rd 23 04:37 PM
Check box - true/false - i'd like a third option n/a Kelly 1st Excel Discussion (Misc queries) 6 February 24th 10 01:23 PM
True or False for a check box Doug Excel Programming 4 December 16th 09 09:06 PM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
check box - true/false/na Kelly 1st Excel Discussion (Misc queries) 4 July 13th 06 12:44 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"