How do I copy a check box result from Worksheet A to Worksheet B?
 

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.

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.

How do I copy a check box result from Worksheet A to Worksheet
 

Thanks Elkar. I tried to right click on the check boxes but neither
"properties" nor
"format control" was an option. This is someone else's spreadsheet. She
said she put it in via the Forms toolbar but it doesn't do what you say when
I right click on it. I tried to import the worksheet into Access to see what
formatting the field really had but it just came in as text. Any other
suggestions? Thanks.

"Elkar" wrote:

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.

How do I copy a check box result from Worksheet A to Worksheet
 

Ok, I'm guessing that the worksheet is protected then. Can you unprotect it?

TOOLS--PROTECTION--UNPROTECT SHEET

If there is a password, then you'd need to get that from the creator.

Once unprotected, you should be able to follow the steps I originally posted.


"Javadan289" wrote:

Thanks Elkar. I tried to right click on the check boxes but neither
"properties" nor
"format control" was an option. This is someone else's spreadsheet. She
said she put it in via the Forms toolbar but it doesn't do what you say when
I right click on it. I tried to import the worksheet into Access to see what
formatting the field really had but it just came in as text. Any other
suggestions? Thanks.

"Elkar" wrote:

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.

How do I copy a check box result from Worksheet A to Worksheet
 

It's not protected.

"Elkar" wrote:

Ok, I'm guessing that the worksheet is protected then. Can you unprotect it?

TOOLS--PROTECTION--UNPROTECT SHEET

If there is a password, then you'd need to get that from the creator.

Once unprotected, you should be able to follow the steps I originally posted.


"Javadan289" wrote:

Thanks Elkar. I tried to right click on the check boxes but neither
"properties" nor
"format control" was an option. This is someone else's spreadsheet. She
said she put it in via the Forms toolbar but it doesn't do what you say when
I right click on it. I tried to import the worksheet into Access to see what
formatting the field really had but it just came in as text. Any other
suggestions? Thanks.

"Elkar" wrote:

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.

How do I copy a check box result from Worksheet A to Worksheet
 

Hmm... I'm not sure why it isn't working for you then. A couple things to try:

1. Make sure when you right-click that you're clicking on the checkbox, and
not the cell behind the checkbox. What menu options do you see when you
right-click?

2. Maybe, if your version of Excel is older than the version the sheet was
created in, that could cause the problem?

3. What happens if you insert a new checkbox onto your worksheet? Do you
see "Format Control" as an option on the new one?



"Javadan289" wrote:

It's not protected.

"Elkar" wrote:

Ok, I'm guessing that the worksheet is protected then. Can you unprotect it?

TOOLS--PROTECTION--UNPROTECT SHEET

If there is a password, then you'd need to get that from the creator.

Once unprotected, you should be able to follow the steps I originally posted.


"Javadan289" wrote:

Thanks Elkar. I tried to right click on the check boxes but neither
"properties" nor
"format control" was an option. This is someone else's spreadsheet. She
said she put it in via the Forms toolbar but it doesn't do what you say when
I right click on it. I tried to import the worksheet into Access to see what
formatting the field really had but it just came in as text. Any other
suggestions? Thanks.

"Elkar" wrote:

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.