Buttons

Why is there no easy way to insert a button. Could be under "Insert" like a textbox.

(Excel for Mac, version 15.21.1)

Thank you very much


Felix

Can a macro be written that adds the content of a cell (or a number) be added to another cell? I simply want to add 1 or 2 or 3, etc. to a cell that contains a value (not a formula). This macro(s) I want then assign to a button.
Another way to put it is to add up the 1s in a cell whenever I click the button "1", and so on.

I am so sorry, I am not that experienced with Macros.
Does "A" mean the address of the cell where 1 has to be added?

I tried as example (to add 1 to cell A1):

Sub Add1()

Cells(1, A1).Value = Cells(1, A1).Value + 1
End Sub

But the macro does not show as executable.

The Cells value is the row number and column (number or letter)

So Cells(1, "A") is the same as "A1"

Hello!

Now i tried:

Sub Add1()

Cells(A1).Value = Cells(A1).Value + 1
End Sub

The macro stops at this line.

Where did I go wrong?

Best regards and thank you

Felix

Please use code tags when posting code:

Should be:

Please Login or Register  to view this content.

å

Why are changing the macro? The example given (pressing the button "Add 1" will add 1, "Add 2" will add 2). This was given as am example: no need to change the macro UNLESS you want to add the number to cell other than A1.