How to work with Form Controls in Excel
In this lecture I will show how to use form controls inside a worksheet.
We will add a Spin Button control. It will be linked in cell F3 and will accept values from 0 to 100. This means that by using the spin button we will be able to change the value of the F3 cell from a minimum value of zero to a maximum of 300.
We click on the Developer tab. If it is not visible you have to customize the ribbon and enable it.
We then insert a new spin button control.
On the developer tab we click on properties and assign the cell link.
Then we change the minimum, and maximum values to the required ones.
We are done. By clicking on the spin buttons, the value in cell F3 changes.