[Solved] Use button to increment a cell

[Dupakos]

Hello I am a beginner
I want to add a button on a spreadsheet
so that when I push it to add 1 to the number in cell A2
(if the value of A2 was 7 to become 8)
could someone tell me how to do it?
But step by step please because I am a beginner.
Lots of thanks
Maria Dupakos

[robleyd]

There is a sample spreadsheet in the last post of this topic which may do what you want.

Alternatively some of these pages may be helpful.

[Dupakos]

Sorry but not understand
What are all these codes ?
told ya am beginner !!!!

[Lupp]

Beginners should probably begin at the beginning.
The insertion and usage of a FormControl (SpinButton in this case?) aren't at that point.
And community forums will possibly not offer personalised introduction starting at any preferred point..
Sorry! Can't change that.

An example file containg a few images related to SpinButton objects was too large to be uploaded here.

=== Editing ===
I found the time to make an example for you containing a few explanations in place of the images:

ask111586_BeginnersQuestion_QM.ods

(14.8 KiB) Downloaded 86 times

As a beginner you should consider to shift to LibreOffice.
It is from a different branch also going back to OO.o, but being much more vital now.
A later, then possibly needed change to LibO would require to adapt to a slightly changed appearance and user interface, and to change some habits adapted to AOO.

[MrProgrammer]

Hello I am a beginner. I want to add a button on a spreadsheet.

As a spreadsheet beginner you probably don't know that buttons are not one of their features. Many spreadsheets, including Calc, allow advanced users to perform programming. It is possible to create buttons with programming. But spreadsheet programming is not for beginners. If you are a beginner you cannot not use buttons.
[Tutorial] Ten concepts that every Calc user should know

… when I push [a button] to add 1 to the number in cell A2

If you want to investigate further, we do have some topics which discuss using a recorded macro to increment cells. You do not need to know any programming to create a recorded macro, but you will need to understand Calc's standard user interface. Though it is quite complicated to create a button, it is less complicated to use a function key or a toolbar to run the macro, but perhaps still complicated for a beginner.
[Solved] Increment/decrement feature for cells
[Solved] How do I increase all variables by 1 with a click?

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.