Right-click the control, and press DELETE. If you have three or more options to evaluate in the same group of options, you can use the CHOOSE or LOOKUP functions in a similar manner. After a user selects one of the two options, the following formula in cell D1 evaluates to "Full-time" if the first option button is selected or "Part-time" if the second option button is selected. Use the returned number in a formula to respond to the selected option.įor example, a personnel form, with a Job type group box, contains two option buttons labeled Full-time and Part-time linked to cell C1.
In the pop-up window, select the Checked option under. To check or tick the checkbox, just double-click it. It will insert a clickable checkbox at your cursor’s location. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. Under the Developer tab, click Legacy Tools button in Controls group and select the Check Box Form Field control. The first option button returns a 1, the second option button returns a 2, and so on. Use the same linked cell for all options in a group. Click in the cell where you want to add the check box or option button control. To add an option button, click the Developer tab, click Insert, and under Form Controls, click. The linked cell returns the number of the selected option button in the group of options. To add a check box, click the Developer tab, click Insert, and under Form Controls, click. In the Cell link box, enter a cell reference that contains the current state of the option button. Unchecked: Displays an option button that is cleared.
In the Format Control dialog box, on the Control tab, you can modify any of the available options:Ĭhecked: Displays an option button that is selected. To format a control, right-click the control, and then click Format Control. Note: The size of the option button inside the control and its distance from its associated text cannot be adjusted.
0 kommentar(er)
