Rename macro button

hi, I'm trying to rename a macro button (see my attached sheet)...
The function is to click "button1" to add 1 to the cell at right (F4).

But as you can see from my sheet the second button2 also adds to the first cell.
this should not happen! it should add to its own cell (F7).

Macro is new to me, any help would be grateful on this...

thanks 6string,
That works, but as I'm going to use 50+ buttons... can all the codes be related to a single macro code.
that's why I what'd to refer to different buttons by name...

One option is to determine the position of the button relative to a cell, then update the value of a cell relative to that cell. However, your shapes have to be placed very precisely for this to work. For example, your first button was located in C4. It may not look like it but the left edge bleeds over into C4 very slightly. I have adjusted it so it's in D4. The other one is in D7. Then the macro updates the cell two cells to the right.

Please Login or Register  to view this content.

that worked thanks

I see you have edited your post; the previous version said your button didn't work. Note from my earlier post:

Originally Posted by 6StringJazzer

...your shapes have to be placed very precisely for this to work.

Your first button has its top left corner in column A but the second is in column B. So the second is trying to update a number two to the right but that's not a number. That's why you're getting the error. You just need to position your shapes carefully.