View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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?