Forum Discussion
How can I add different values to different cells on the press of a single button (SpinButton)
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..
jvs95 See attached.
Edit: You'll find the spinner on the Developer ribbon. Once inserted, right-click on it to change the settings.
5 Replies
- Riny_van_EekelenPlatinum Contributor
jvs95 Perhaps something like this?
D3 is the cell linked to the spinner button, incrementing or decrementing by 1 on each press.
- jvs95Copper ContributorDoes that work? How do I set up the spinner...
could you send the file, please?- Riny_van_EekelenPlatinum Contributor
jvs95 See attached.
Edit: You'll find the spinner on the Developer ribbon. Once inserted, right-click on it to change the settings.
- wangzheCopper Contributor