Form Controls

Form Controls

December 2, 2018

Form Controls in Excel allow you to guide how users enter data in a worksheet.   On the Developer tab, you'll see 9 options in the Insert menu.

 

 The command button allows you to run a macro when the button is clicked. 

 A combo box will allow users to select options from a drop down list. 

 

A check box can be used to enter either TRUE or FALSE in a designated cell depending on whether the box is checked or unchecked.

 

 

The spin button can be used to increase or decrease a value in a linked cell.

 

 

The minimum, maximum and incremental value can be set for the cell.

 A list box lets a user choose from a list of items, and then assigns the number of the item to a designated cell.  

 Option buttons in a group box allow a user to select one of multiple choices to enter in a designed cell.

The label button simply adds text to describe a form control.

 

Finally a scroll bar allows you to scroll back and forth to change the value in a designated cell.

 

Right click on any of these form controls in order to resize or reset them. 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com