Search results
Results From The WOW.Com Content Network
An option button can have one of three states: selected (turned on), cleared (turned off), and mixed, meaning a combination of on and off states (as in a multiple selection). An option button is also referred to as a radio button.
You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.
Learn how to position and size a control on a worksheet.
You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice.
You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.
After you add Form and ActiveX controls to a worksheet form, you may want to group, copy, move, or align controls to create a well designed, user friendly form. To perform any of the procedures in this article, if one or more controls is an ActiveX control, you must first make sure that the Developer tab is available. Display the Developer tab.
Select or deselect controls on a worksheet. You can group, copy, resize, or format controls on a worksheet form. You cannot combine Form controls or ActiveX controls with Drawing Tools or SmartArt Tools objects (such as Shapes and SmartArt graphics) in the same group selection. Make sure the Developer tab is visible on the ribbon.
See how to work with ActiveX controls in your files, changing their settings, and how to enable or disable them by using the Message Bar and the Trust Center. You can also learn more about ActiveX controls and how they improve your files.
You can use a button (a form control) to run a macro that performs an action when a user clicks it. For example, you might use a button to automate the printing of a worksheet, the filtering of data, or the calculation of numbers.
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. To remove checkboxes: Select the range of cells with the checkboxes you want to remove.
On the Developer tab, in the Controls group, turn on Design Mode . Select the control or controls that you want to delete. For more information, see Select or deselect controls on a worksheet. Press DELETE.