How do I link one checkbox to update another checkbox?

[Mike]

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?

[Jim Cone]

Use the same linked cell for both.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Mike" <Mike@discussions.microsoft.com>
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?

[Mike]

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" <Mike@discussions.microsoft.com>
> 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?
>

[Jim Cone]

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" <Mike@discussions.microsoft.com>
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" <Mike@discussions.microsoft.com>
> 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?
>