I'm need help in how to increase the cell value by one by clicking the mouse in that cell. I have to tally the results from 100s of paper surveys, and being able to simply click on the a specified cell each time for each individual response would be helpful.
I know the basics of Excel but a complete novice when it comes to formulas, macros, code, etc. Thanks!
Have a look at the attached.
Double click on a cell in column B to increase the count by one.
Hope it helps,
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi excelnovicedc and welcome to the forum. Place the following code in your worksheet module
Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Dom, thanks for your generosity in generating and sharing this. It has helped me immensely in itself AND I've used it to start learning about VE. Thanks, Karen
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks