| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
| VBA | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Linear Mode
