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. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. 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. The linked cell returns the number of the selected option button in the group of options. 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. You can follow the question or vote as helpful, but you cannot reply to this thread. To format a control, right-click the control, and then click Format Control. I need to insert a check box to Microsoft Word 2003, so everytime I click on the box it will automatically go from a clear box to a box with an X in the middle. Note: The size of the option button inside the control and its distance from its associated text cannot be adjusted.

How to insert check mark in word box