Spin Button In Excel VBA
Spin button is one of VBA forms in Excel. It can be useful in spreadsheets, formulas and charts.
To insert spin button first go to Ribbon > Developer tab > Insert > Form controls and click Spin button.
Put spin button in your spreadsheet and adjust size. It should look like this:
To configure spin button click right button and go to Format control > Control tab.
Choose Minimum value, Maximum value, Incremental change and link spin button with a cell.
Now you can increase or decrease value in the cell. In this way you can change values of cells which are connected with formulas or charts.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
