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")

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")

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")

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")