Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF checkbox is checked/unchecked, Cell.value = yes/no
Hi,
this may be a very quick question... Using the Control Toolbox, I have a single checkbox on each sheet of a 56 sheet workbook. if that sheet is "completed" the checkbox is to be checked. Now i have a summary sheet that shows what sheets are "Completed" how do i write a cell function that will put yes or no depending on the true/false of the checkbox? Thanks! this is a sample of my summary sheet something like this: A B sheet1 =IF(sheet1.checkbox1, "yes", "no") sheet2 =IF(sheet2.checkbox1, "yes", "no") sheet3 =IF(sheet3.checkbox1, "yes", "no") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF checkbox is checked/unchecked, Cell.value = yes/no
Link the check box to a cell (use the same cell on each sheet). Assume the
linked cell (on each sheet) is cell A1. Then use a formula like this: =IF(Sheet1!A1,"Yes","No") Or, with your sheet names listed starting in cell A1 on your summary sheet: =IF(INDIRECT("'"&A1&"'!A1"),"Yes","No") Copy down as needed -- Biff Microsoft Excel MVP "James" wrote in message ... Hi, this may be a very quick question... Using the Control Toolbox, I have a single checkbox on each sheet of a 56 sheet workbook. if that sheet is "completed" the checkbox is to be checked. Now i have a summary sheet that shows what sheets are "Completed" how do i write a cell function that will put yes or no depending on the true/false of the checkbox? Thanks! this is a sample of my summary sheet something like this: A B sheet1 =IF(sheet1.checkbox1, "yes", "no") sheet2 =IF(sheet2.checkbox1, "yes", "no") sheet3 =IF(sheet3.checkbox1, "yes", "no") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF checkbox is checked/unchecked, Cell.value = yes/no
The sheet1, sheet2, etc in column A is just the name of a specific sheet.
might have been confusing "James" wrote: Hi, this may be a very quick question... Using the Control Toolbox, I have a single checkbox on each sheet of a 56 sheet workbook. if that sheet is "completed" the checkbox is to be checked. Now i have a summary sheet that shows what sheets are "Completed" how do i write a cell function that will put yes or no depending on the true/false of the checkbox? Thanks! this is a sample of my summary sheet something like this: A B sheet1 =IF(sheet1.checkbox1, "yes", "no") sheet2 =IF(sheet2.checkbox1, "yes", "no") sheet3 =IF(sheet3.checkbox1, "yes", "no") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF checkbox is checked/unchecked, Cell.value = yes/no
Check your checkbox properties, under LINKED CELL. Put the cell that you want
TRUE or FALSE to be populated into. My usual personal preference is to link the cell that the checkbox is actually in. Then I just make the font white in the cell so as to not actually see the TRUE, FALSE being covered up by the checkbox. Hope this helps. -- John C "James" wrote: Hi, this may be a very quick question... Using the Control Toolbox, I have a single checkbox on each sheet of a 56 sheet workbook. if that sheet is "completed" the checkbox is to be checked. Now i have a summary sheet that shows what sheets are "Completed" how do i write a cell function that will put yes or no depending on the true/false of the checkbox? Thanks! this is a sample of my summary sheet something like this: A B sheet1 =IF(sheet1.checkbox1, "yes", "no") sheet2 =IF(sheet2.checkbox1, "yes", "no") sheet3 =IF(sheet3.checkbox1, "yes", "no") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Delete old data when checkbox is unchecked | Excel Discussion (Misc queries) | |||
Delete range on another sheet when checkbox is unchecked | Excel Discussion (Misc queries) | |||
Gridline box checked or unchecked. Gridlines do not print. | New Users to Excel | |||
Is checkbox is checked? | Excel Discussion (Misc queries) |