Forum Discussion

FutureMrsPitts's avatar
FutureMrsPitts
Copper Contributor
Dec 09, 2022

I cant figure this out and its making me mad 🤦🏼‍♀️🤦🏼‍♀️

Okay, so I need a click counter.

Like Below⬇︎

But I need to set it up to have it where I can count a total of three different things. 

Another Pic ⬇︎

 

My thought was to make three "Buttons" and have each button set up to Cells A2, B3, and C3.

Like  so⬇︎

 This is where I need guidance on how THE HECK do you do this 🤦🏼‍:female_sign:

 

Is it as simple as putting 0 in all three Cells and attaching  =A2+1........ If so I still have no idea how to do that Send help

PS. I am on a Mac

 

 

1 Reply

  • Rodrigo_'s avatar
    Rodrigo_
    Steel Contributor

    FutureMrsPitts 

    Go to Developer tab -> Insert -> select Spin Button (Form Control)
    then, place it wherever you want on your sheet,
    after placing it, Right Click on the object, click on Format Control, and look for "Cell link", and select the cell you want to have your counter. ex.: =A2
    and Tada! It will work as a tally counter like on the image you want.