A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
The first step is to add a macro to bump the value in a cell every time the macro is called:
Sub tally()
Range("A1").Value = Range("A1").Value + 1
End Sub
The next step is to run a macro to make the button:
Sub button_maker()
Dim r As Range
Set r = Selection
ActiveSheet.Buttons.Add(94.5, 75.75, 51, 27.75).Select
Selection.OnAction = "tally"
ActiveSheet.Shapes(1).Select
Selection.Characters.Text = "Bump"
r.Select
End Sub
Each time the button is clicked, the value in A1 will increment. Change A1 to suit your needs.
Macros are very easy to install and use:
- ALT-F11 brings up the VBE window
- ALT-I
ALT-M opens a fresh module
- paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
To use the macro from Excel:
1. ALT-F8
2. Select the macro
3. Touch RUN
To learn more about macros in general, see: