SOLVED

How can I add different values to different cells on the press of a single button (SpinButton)

Copper Contributor

How do I make it so that using a SpinButton or another button trinket, on a single press of the up button or down button, I add or remove different values to different cells, for example: +10/-10 to A1, +1.5/-1.5 to B1, +20/-20 to C1 

I'm making a level up progression sheet for characters in a game I'm making - and they all have different hp and mana growth per level. Having a button add all the different values at once would make things easier..

5 Replies

@jvs95HALF answer wish can help you to next level ^_^

@jvs95 Perhaps something like this?

Screenshot 2021-07-15 at 07.44.10.png

D3 is the cell linked to the spinner button, incrementing or decrementing by 1 on each press.

Does that work? How do I set up the spinner...
could you send the file, please?
best response confirmed by jvs95 (Copper Contributor)
Solution

@jvs95 See attached.

 

Edit: You'll find the spinner on the Developer ribbon. Once inserted, right-click on it to change the settings.

Ahh I should have thought of that...
Works phenomenally, thanks for your help.
1 best response

Accepted Solutions
best response confirmed by jvs95 (Copper Contributor)
Solution

@jvs95 See attached.

 

Edit: You'll find the spinner on the Developer ribbon. Once inserted, right-click on it to change the settings.

View solution in original post