Excel VBA Spin Button: User-Friendly Interactivity

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

Further reading: 
Basic concepts 
Getting started with Excel
Cell References