Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Boxes | New Users to Excel | |||
Check boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |