Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I link one checkbox to update another checkbox?
I have a checkbox in one sheet that I want to update the equivalent checkbox
in another sheet when it is selected. Both sheets are in the same workbook. I can this be done please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I link one checkbox to update another checkbox?
Use the same linked cell for both.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mike" wrote in message I have a checkbox in one sheet that I want to update the equivalent checkbox in another sheet when it is selected. Both sheets are in the same workbook. I can this be done please? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I link one checkbox to update another checkbox?
Jim this has not worked. I can only guess because I am using the checkbox
form control and therefore it is separate to the actual cell. Any ideas? "Jim Cone" wrote: Use the same linked cell for both. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mike" wrote in message I have a checkbox in one sheet that I want to update the equivalent checkbox in another sheet when it is selected. Both sheets are in the same workbook. I can this be done please? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I link one checkbox to update another checkbox?
It works for me for the checkboxes from the Forms Toolbar and the
checkboxes from the Control Toolbox. For the checkbox that is on the "other" sheet the linked cell reference must include the sheet name... Sheet1!$A$1. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Mike" wrote in message Jim this has not worked. I can only guess because I am using the checkbox form control and therefore it is separate to the actual cell. Any ideas? "Jim Cone" wrote: Use the same linked cell for both. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mike" wrote in message I have a checkbox in one sheet that I want to update the equivalent checkbox in another sheet when it is selected. Both sheets are in the same workbook. I can this be done please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I update a date formula only if checkbox changes? | Excel Worksheet Functions | |||
How do I update a checkbox as true when another has been updated | Excel Worksheet Functions | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
CheckBox in VBA | Excel Programming |