spot_img

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
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial