Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box
Can you get an Excel check box to link to another cell/worksheet? I tried
this, but it just returns a "0", and doesn't acknowledge the check or check box. I wonder if I have to just use a standard cell & manually type an "X" to get a link to another cell/worksheet. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box
If you're using the check box off the FORMS controls toolbar, right click on
the checkbox after placing it in the cell and click the CONTROL tab and enter the sheet name and cell address Sheet1!A1 If you're using the checkbox on the CONTROLS toolbar after inserting the check box, right click and select properties. On the ALPHABETIC tab, locate the LINKEDCELL property and enter the sheet name and cell address. When done turn design mode off by clicking the button on the CONTROLS toolbar that has the pencil/ruler/triangle icon. Hope this helps. -- Kevin Backmann "Gravy Man" wrote: Can you get an Excel check box to link to another cell/worksheet? I tried this, but it just returns a "0", and doesn't acknowledge the check or check box. I wonder if I have to just use a standard cell & manually type an "X" to get a link to another cell/worksheet. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box
One of the Checkbox Properties is Linked Cell. Type in the cell you wish to
have linked to the checkbox (my personal preference is to link to the cell the checkbox is actually in, then change the formatting of the cell to Font-White). This will populate the cell with either TRUE or FALSE depending on the status of the checkbox. Then you can reference the cell for your needs. Hope this helps. -- John C "Gravy Man" wrote: Can you get an Excel check box to link to another cell/worksheet? I tried this, but it just returns a "0", and doesn't acknowledge the check or check box. I wonder if I have to just use a standard cell & manually type an "X" to get a link to another cell/worksheet. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the check mark boc bigger on the check box? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) |