Buttons interacting with IF statements

[sighlent1]

Is there a way that i could have a checked button interact with a IF statement

Example:

IF(Box is Checked,A1+5,A2+5)


i just don't know the code, or even if there is any code for this

Thank you and i appreciate your time,
Bob

[JONvdHeyden]

Hi Bob

Use the check box from the control toolbar. You can set it wto write to a cell in the format control (Cell Link). TRUE if checked, else FALSE.

Lets assume it's writing to B1, then you could use the following:

=IF(B1,A1+5,A2+5)

EDIT: You can also use a checkbox from the control toolbox and link it to a cell in the properties.

[sighlent1]

I'm sorry, i'm a little confused...if it's not a problem, would you mind showing me through excel?

Thank you,
Bob

[ChemistB]

Attached are examples of the Forms Checkbox and the Active X checkboxes.
I have the forms Checkbox linked to A1 and the Active X checkbox linked to A2. I also pasted in screen shots of how they are linked. For Forms, right click and "Format Control" For Active X, Right click and select Properties.
Typically, I pick the cell underneath the checkbox itself so you don't actually see the True/False. Then set up your IF statement as Jon described. Make sense?

[JONvdHeyden]

Attached includes instructions.

I'm on xl2003 (office app) so uploaded in .xls format.