How to work with Form Controls in Excel

Published: 03 April 2019
on channel: LEARN IT in 30 seconds by TEST4U

13,473

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.

Watch video How to work with Form Controls in Excel online, duration hours minute second in high quality that is uploaded to the channel LEARN IT in 30 seconds by TEST4U 03 April 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 13,473 times and liked it 20 visitors.

734