button i can press that subtracts 3 from a specific cell and adds 1 to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2740656%22%20slang%3D%22en-US%22%3Ebutton%20i%20can%20press%20that%20subtracts%203%20from%20a%20specific%20cell%20and%20adds%201%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2740656%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20all%20i'm%20trying%20to%20make%20a%20excel%20document%20for%20diablo%202%20to%20track%20how%20many%20runes%20i%20got%20and%20i%20need%20a%20why%20to%20make%20a%20button%20that%20ses%20craft%20that%20needs%20to%20take%20off%203%20from%20the%20rune%20befor%20and%20add%201%20to%20the%20next%20tier%20of%20the%20rune%20in%20tern%20using%203%20of%20befor%20one%20to%20craft%20the%20next%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20can't%20seem%20to%20figure%20out%20the%20macro%20i%20need%20for%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20the%20pic%20i%20added%20i%20want%20the%20add%20button%20to%20add%201%20to%20cell%20E3.%20and%20the%20craft%20button%20needs%20to%20take%20off%203%20from%20cell%20E2%20and%20add%201%20to%20cell%20E3%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2740656%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
Occasional Visitor

hello all i'm trying to make a excel document for diablo 2 to track how many runes i got and i need a why to make a button that ses craft that needs to take off 3 from the rune befor and add 1 to the next tier of the rune in tern using 3 of befor one to craft the next one.

 

but can't seem to figure out the macro i need for it.

 

in the pic i added i want the add button to add 1 to cell E3. and the craft button needs to take off 3 from cell E2 and add 1 to cell E3

0 Replies