LinkBack URL
About LinkBacks
Hello
I want to create a clickable counter that will increase by multiples of 1 everytime it is clicked. Can someone please advise?
Thanks
Sam
Hello
I want to create a clickable counter that will increase by multiples of 1 everytime it is clicked. Can someone please advise?
Thanks
Sam
I am not sure about single click but you can do this using double click.
Right click on the sheet where you want the increment to happen, select View code and copy this code -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I am a little confused. I want to have a button that i can click and i will be able to see the numbers increasing. Like a tally. I am not the best on excel so need a walk through really. Thanks for the advice.
Where are the numbers located? In which cells?
You can use a helper sheet and have a sequential list of numbers up to the highest value you want.
Sample code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks