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