View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default How do I copy a check box result from Worksheet A to Worksheet B?

Did you link the checkboxes to the cells in Column A? Just placing the
checkbox in a cell doesn't actually link the checkbox value to that cell.

Depending which type of checkbox you used (Forms or Controls), you'll need
to edit the properties of the checkbox and tell it which cell to link to.

For Forms Checkboxes:
- Right-Click on the checkbox
- Select "Format Control"
- Select the "Control" tab
- Enter a cell reference in the "Cell link:" box
- OK

For a Control Checkbox:
- Right-Click on the checkbox
- Select "Properties"
- Enter a cell reference in the "LinkedCell" field
- Close the Properties window

HTH,
Elkar



"Javadan289" wrote:

I have check boxes in column A on Worksheet A. I tried to link column A on
Worksheet B to column A on Worksheet A but it doesn't carry over the values
as checked or unchecked. How can I get them to carryover to Worksheet B? I
even tried to write a TRU/FALSE formula but it always came out as FALSE no
matter what was on Worksheet A. Thanks.