I’m into playing RPG games and i tend to make Exel sheets to keep track of all the stats
that i developed on every lvl. Recently i thought of modernizing my template file with +1/-1 increment.
I found on the net what i want and my sight is set on Spin Button in Form Controls.
Now there is a tedious part. My template have 50 columns and 70 rows and every cell need this button.
And for every cell i would need to set manually in Data Tab in Properties of each button the linked cell.
that’s 300 buttons to manually set up.
The question is can i make a single one Spin Button that will increase the value of the cell i click on (Active Cell).
Or i could make 2 Push Buttons one for +1 and one for -1 that will work with an Active Cell?
The idea for that came from a forum post i read on open office forum
Can i write some magic thing in Linked Cell in Data tab for it to affect the cell i click on and not the set single cell?