In this lesson you will learn how to create and configure spin button in Excel.

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.