In this lesson you will learn how to create and configure spin button in Excel.
Insert a form
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:
Format the Spin Button
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.