![]() |
Use of Check Boxes
I'm interested in using a check box in a column on a worksheet. I would like
to be able to toggle the check box on or off to include or exclude the check. Where can I find the help instruction for doing this? |
Use of Check Boxes
I'm interested in using a check box in a column on a worksheet. I
would like to be able to toggle the check box on or off to include or exclude the check. One way is to start with the "Forms" tool bar. Make this appear by right- clicking in the toolbar area and checking "Forms." Click on the check box in the Forms tool bar and then click in the spreadsheet. This should make a check box appear. You can move it around and resize it. Then, using Right-click Format Control you can change its appearance and behavior. Most interesting is Format Control's "Control" tab. Using it, you can assign a "Cell link," choosing a worksheet cell to store the state of the check box (checked or not). This lets you do calculations based on this state. (I have Excel 2003.) |
All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com