Buttons to increment adjacent cell values

Hi everyone, my first post on here - I hope you can help me!

I am trying to create some buttons which increment the value of a nearby cell up or down depending on whether the "+" or "-" button was clicked. Let me explain further....

I have a long table of data containing names of cards, and I want the user to be able to record the number of each card that they own. I thought the easiest way would be to have a spin button next to each row of the table where the user can click the Up and Down buttons to increment the number in the "Owned" column +/-1.

I can make this work fine for one row of the table, by using the following code attached to the SpinButton1 (which is located one cell to the right of the "Owned" column):

Please Login or Register  to view this content.

My problem is that I will have hundreds of these things and I think I'm right in saying that each new button will have to have a unique name, meaning I will have to copy/paste this code for each one and change the reference to the button (i.e. SpinButton2,3,4,5..... etc) which would be very time consuming. Is there an easy way to do this? Can anyone please suggest a way of assigning this code to a whole stack of spin buttons?

Thanks in advance, guys

Maybe try moving the button?

Please Login or Register  to view this content.

Thank you both for your fine suggestions, I think I'll go with millz suggestion for moving the button. This works really nicely and doesn't require a huge number of buttons and coding.

HaHoBe, I was wondering if your idea could be changed slightly so that instead of running the code on DoubleClicks and RightClicks, it ran when the user tried to type a + or - sign into a cell, i.e. it would increment the value up or down? Is it possible to capture such keystrokes and prevent them from having their normal effect (which, in this case, would be to type a + or - sign into the cell)?

Thanks guys, I really appreciate your help.