LinkBack URL
About LinkBacks
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.
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.
Can you please brief your requirement further for better understandingOriginally Posted by icesaiah
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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.
-------------
Tony
Thanks BeachRock!!! This is what I need...
Follow up question, what if I want that every time I click a cell it will also add up on that same cell?
Hmm, you got me there. I don't know. Sorry. At least now you know more of what to search for though.
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...
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...
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.
It worked!!!
Glad it helps you and thanks for the feedback and rep
Can I change the double click to Enter button?
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.
Copy the below code and paste it in STANDARD module.Please Login or Register to view this content.
How to install code in STANDARD MODULE
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
Thanks again Sixthsense...
You're the BEST!!!
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.
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!
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
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.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks, Ford. have just re-submitted my query, this time as a new thread.
looks like a lot of knowledge on this forum.
bill22x
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks