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