refering to checkboxes in formulae

C

Charlie

Yes you can have a formula read the check box. The check
box must be linked to a cell. In design mode right click
on the check box and select properties. Look for
LinkedCell and enter for example A1. Close the properties
window. Move the check box over A1 to hide the cell. Now
in B1 enter =If(A1=True,1,0).

Charlie O'Neill
-----Original Message-----
You can use the check box option in the control toolbox
toolbar to create checkbox objects.
But is it possible to have formulae read from said checkboxes?
For example, =if(checkbox=checked,1,0) where the cell has
a value of 1 if the checkbox is checked and a value of 0
if it is empty.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top