Buttons

[fak119]

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

(Excel for Mac, version 15.21.1)

[jaslake]

Hi fak119

Welcome to the Forum!!!

Select Developer ---> Button ----> Draw the Button.

If the Developer Tab is not visible...

Click on Excel ---> Preferences ---> Ribbon ---> Select Developer.

[fak119]

Thank you very much


Felix

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[fak119]

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.

[MarvinP]

Hi fak,

See if this code and the example help with your problem.

Please Login or Register  to view this content.

Button Click to Add to a cell.xlsm

[fak119]

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.

[shirleyxls]

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

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

[fak119]

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

[Kyle123]

Please use code tags when posting code:

Should be:

Please Login or Register  to view this content.

å

[JohnTopley]

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.