Home VBA TutorialVBA Spin Button In Excel VBA

Spin Button In Excel VBA

by Easy Excel Tutorials

Spin Button In Excel VBA

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.

Excel Insert Spin Button




Put spin button in your spreadsheet and adjust size. It should look like this:

Excel Spin Button Size

To configure spin button click right button and go to Format control > Control tab.

Excel Spin Button Format Control




Choose Minimum value, Maximum value, Incremental change and link spin button with a cell.

Excel Spin Button Properties

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

You may also like