Tuesday, February 15, 2011

How to Make One Checkbox Uncheck Another in Excel 2003


1. Open Excel 2003, and launch your Excel spreadsheet. Make sure the Forms toolbar is switched on by clicking 'Views > Toolbars > Forms.'
2. Click the 'Combo Box' form control, and drag it to your worksheet.
3. Right-click the box, and click 'Format Control.' Set the 'Input range' to the range of cells that contains the check box values.
4. Set the 'Cell link' to the cell that will return the result of your check box. Click 'OK' to insert the combo check box.

Blogger news