[HELP] Creating Tally Counter

[icesaiah]

Hi everyone,

I would like to seek help in creating a tally counter in excel.

What I want is when I click the cell it will add on the count.

Please help.

[:) Sixthsense :)]

What I want is when I click the cell it will add on the count.

Can you please brief your requirement further for better understanding

[BeachRock]

Hi icesaiah,

If what you are talking about is being able to just double click a cell and have the value change from 0 to 1 or 1 to 0, then you need a Worksheet Event.

See attached. Double click on any of the cells you want to add a 1 or remove a 1 and the totals add up n the bottom.

[icesaiah]

Thanks BeachRock!!! This is what I need...

[icesaiah]

Follow up question, what if I want that every time I click a cell it will also add up on that same cell?

[BeachRock]

Hmm, you got me there. I don't know. Sorry. At least now you know more of what to search for though.

[icesaiah]

No worries.

I tried to change the code to make 1 + 1 and it worked but after it changes to 2 I can't click it anymore...

[icesaiah]

Hi Sixthsense...

What I want is that every time I click on a cell it will count. For example I click cell B3, it will show 1 then if I click it again it will show 2 and so on...

[:) Sixthsense :)]

Do right click on sheet tab and select view code and paste the below code… Return to excel and check…

Please Login or Register  to view this content.

[icesaiah]

It worked!!!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

[icesaiah]

Can I change the double click to Enter button?

[:) Sixthsense :)]

Copy the below code and Do right click on sheet tab and select view code and delete all the previously suggested code and past this one.

Please Login or Register  to view this content.

Copy the below code and paste it in STANDARD module.

How to install code in STANDARD MODULE

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

[icesaiah]

Thanks again Sixthsense...

You're the BEST!!!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[redhanded]

Hi

I've just registered and downloaded the template and used the modified code to tally data I'm collating from hard copy surveys. It's going to save me hours of work. Very grateful to you Sixthsense for sharing!

[bill22x]

I want to make tally counter with minimum key pushes to add +1 to the count of a key word.

have a couple hundred responses from different groups of people and want to get frequency counts of key words and concepts.
as i read the responses, want to enter a new key word or add to the count of words already encountered.
i don't mind positioning the cursor each time, and then pressing a key (or few) to add 1 to that corresponding count cell.

this programming is new to me. many years ago, ok with fortran and have worked some in excel, but don't seem to know enough to do this.

thank you to anyone who can help.

bill

[FDibbins]

Bill, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[bill22x]

thanks, Ford. have just re-submitted my query, this time as a new thread.

looks like a lot of knowledge on this forum.

bill22x