Adding Spin Button Count to another cell

[nitro22888]

Hello everyone! I am 100% new here, so bare with me as I try to navigate the forum. I have been struggling to solve an issue and I thought maybe some of you all might be of some help.

I am creating a "Basketball Box Score" -- if you are not familiar with it, it just keeps track of each player's statistics throughout a game (shot attempts, rebounds, points, steals, etc). My issue is with the "Made Shot attempts" (or field goals) and "Total Shot Attempts". What I want is to have a spin button for both cells, but for the TOTAL shot attempts to go up by one if I click on either spin button. As a game is played, sometimes multiple shots are put up in a matter of seconds, and it would be easier to just hit one spin button for a made shot than having to click both.

The way it's pictured in my mind is that the total shot attempts has it's own value increasing by one, and that value is summed with the value in the made shot attempts box. The problem is, I can't find a way to do this without creating a third cell -- for MISSED shot attempts, for instance. But the problem with that is I don't have space for it, and if I create it on another sheet I'd have to go to that sheet each time if I wanted to clear the box score, which would be ideal.

Is there anything I can do to combine these two spin button values in a single cell?

[Tony Valko]

You have each spinner linked to separate cells?

Then just sum both linked cells...

=A1+B1

[nitro22888]

Thanks for responding. There is a spinner for two separate cells, but adding them as you suggested would require a third cell.

I'm trying to avoid a third cell. So for instance there is a spinner for A1 and B1, and in B1 I want it to increase by 1 when I click either spinner.

[Tony Valko]

I think you'd need VBA code to do that.

I'm not much of a programmer so I can't help.

[nitro22888]

Hmmm I'm not familiar VBA codes. Can you point me in the direction where I might find more information about it?

[Tony Valko]

I didn't know this was possible but I just tried it...

You can link both spinners to the same cell!

Will that do what you want?

[nitro22888]

That helps! I just tried it now too, since you mentioned it. Can you also make a single spinner apply to two cells? If I can get the A1 spinner to apply to A1 and B1, and then have another spinner for B1, that would solve it.

Do you know if that's possible?

[Tony Valko]

Can you also make a single spinner apply to two cells?

You can link to one cell and put a formula in the other cell...

A1 = linked cell

B1: =A1

[nitro22888]

Well the problem with using a formula is, since there's a spinner on B1 it won't let you also have a formula in B1. Once you click the spinner it overrides the formula.

Your suggestion of linking 2 spinners to one cell is great. I just need one of the 2 spinners to apply to a second cell to make it work.


Capture.PNG


That's a picture of how it works. The spinner in cell 1 has to apply to both, while the spinner in cell 2 still working for that cell. A formula will just get overridden if a spinner is used, so I gotta do it another way.

Logically it seems really simple, but excel seems to have made it difficult to have one spinner count in 2 cells. I know there's a way, I just haven't found it yet.

[Tony Valko]

Well, I'm out of suggestions!

Try posting in the Excel Programming / VBA / Macros forum. Include a link to this thread so folks can see what has already been discussed.

[nitro22888]

Alright, thanks for the suggestions!