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

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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?