how can I link the status of a checkbox in excel to a field value.

[Guest]

I am trying to develop a form that can be filled in on the screen yet looks
decent when printed. I have managed to insert checkboxes for a true or false
question, however I can not figure out how to refer to whether the checkboxes
are checked or not through a cell function.

The reason is that I would like to refer to the checkboxes in a conditional
count function.

 

[Dave Peterson]

If you got the checkbox from the Forms toolbar, right click on it and select

Format Control|Control Tab
Assign it a nice cell link.

Then when the checkbox is checked, you'll see TRUE in that cell.

If you got the checkbox from the Control Toolbox Toolbar, right click on it
and select

Properties
Look for linked cell and type in the address of a cell.

(You'll have to be in design mode--another icon on that toolbar for the
rightclick to work.)

If you put them all in a nice column, you can count all the checkboxes with:

=countif(a1:a22,true)

And you can use:

=if(a1=true,"it's checked","nope")

for the checkbox linked to A1.

(You may want to hide that column to make the print output nicer.)