SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2550376%22%20slang%3D%22en-US%22%3EHow%20can%20I%20add%20different%20values%20to%20different%20cells%20on%20the%20press%20of%20a%20single%20button%20(SpinButton)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550376%22%20slang%3D%22en-US%22%3E%3CP%20data-unlink%3D%22true%22%3E%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3EHow%20do%20I%20make%20it%20so%20that%20using%20a%20SpinButton%20or%20another%20button%20trinket%2C%20on%20a%20single%20press%20of%20the%20up%20button%20or%20down%20button%2C%20I%20add%20or%20remove%20different%20values%20to%20different%20cells%2C%20for%20example%3A%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3E%2B10%2F-10%20to%20A1%2C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3E%2B1.5%2F-1.5%20to%20B1%2C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3E%2B20%2F-20%20to%20C1%3C%2FSPAN%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20making%20a%20level%20up%20progression%20sheet%20for%20characters%20in%20a%20game%20I'm%20making%20-%20and%20they%20all%20have%20different%20hp%20and%20mana%20growth%20per%20level.%20Having%20a%20button%20add%20all%20the%20different%20values%20at%20once%20would%20make%20things%20easier..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2550376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550430%22%20slang%3D%22zh-CN%22%3EReply%3A%20can%20How%20I%20add%20different%20values%20to%20different%20cells%20on%20the%20press%20of%20a%20single%20button%20(SpinButton)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550430%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103873%22%20target%3D%22_blank%22%3E%40jvs95%3C%2FA%3E%20HALF%20answer%20wish%20can%20help%20you%20to%20next%20level%20%5E_%5E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550839%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20add%20different%20values%20to%20different%20cells%20on%20the%20press%20of%20a%20single%20button%20(SpinButton)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103873%22%20target%3D%22_blank%22%3E%40jvs95%3C%2FA%3E%26nbsp%3BPerhaps%20something%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-07-15%20at%2007.44.10.png%22%20style%3D%22width%3A%20349px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296021i80900485AB679F7C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-07-15%20at%2007.44.10.png%22%20alt%3D%22Screenshot%202021-07-15%20at%2007.44.10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ED3%20is%20the%20cell%20linked%20to%20the%20spinner%20button%2C%20incrementing%20or%20decrementing%20by%201%20on%20each%20press.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550875%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20add%20different%20values%20to%20different%20cells%20on%20the%20press%20of%20a%20single%20button%20(SpinButton)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550875%22%20slang%3D%22en-US%22%3EDoes%20that%20work%3F%20How%20do%20I%20set%20up%20the%20spinner...%3CBR%20%2F%3Ecould%20you%20send%20the%20file%2C%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550878%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20add%20different%20values%20to%20different%20cells%20on%20the%20press%20of%20a%20single%20button%20(SpinButton)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550878%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103873%22%20target%3D%22_blank%22%3E%40jvs95%3C%2FA%3E%26nbsp%3BSee%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20You'll%20find%20the%20spinner%20on%20the%20Developer%20ribbon.%20Once%20inserted%2C%20right-click%20on%20it%20to%20change%20the%20settings.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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.