adding a tally for tick boxes

[Rosszx10r]

Hi need to make a simple form like bellow

Names Happy ok unhappy
bob
dave

they then tick a box under happy ok or unhappy,what i need is to keep the results of how many times they have said any of the above.
so one day bob ticks happy=1 next day happy=1 to tally is two and so on?

Thanks

[Glayva]

It's hard to picture this when we don't have an example spreadsheet (it's always good to upload one) but it sounds like you might be able to use s drop down yes/no box for each day and then us a pivot table to collate the results.

[Rosszx10r]

Here is sample attached

Thanks

[DBY]

Hello
You need to Right click each Check box and Format Control to assign a Cell link, then count the TRUE and FALSE values, perhaps with the Countif function.

Hope this helps.
DBY

[Rosszx10r]

Yes i have done =Countif true = 1 and so on but this doesnt create a tally of keep track of how many times happy has been tick'ed

[DBY]

Have you linked the Check boxes to cells in order for the Countif to count?

[Rosszx10r]

yes i get a 1 when i ticket thats fine, so say i tick box i then get a 1 in C1 i then want that 1 to be counted in D1. But then i restet form, tick box again i want D1 to then count two? do you understand?

[DBY]

I think I get it. To do that you're going to have to use some VBA code to create a counter of the number of times a particular box is ticked.

[Rosszx10r]

ok can anyone help with that?

[DBY]

Hi
I Know a little VBA but I'm no expert. You will probably have to replace your check boxes with Active X controls and then apply some code such as:

Please Login or Register  to view this content.

That should increment D1 by 1 every time the check box is TRUE.

[Rosszx10r]

Ah that seems to have done it thanks

[DBY]

Glad to have helped. If you need more information about VBA then post in the VBA forum, perhaps with a link back to this thread as reference. There are some VBA experts here who might be able to help you further.

DBY

[Rosszx10r]

ok one last question if i do this how do i get the tally to fill out on another sheet

[DBY]

Hi
You would just reference the sheet in the code, for example in it's simplest form to put the count in sheet 2:

Please Login or Register  to view this content.

DBY