Add a checkbox to a spreadsheet

[beurling]

Hi!

I'm totally new to macros and I don't get checkboxes to work at all..

What I'm trying to do is add a checkbox(actually multiple checkboxes) and
have these checkboxes interfere with other cells. for example like this:
A1: checkbox
A2: if(checkbox=true;1;2) (just to make the example easy)

I hope someone can help.

regards

 

[Gary Brown]

Assuming that (1) you have the checkbox directly on a worksheet and NOT on a
form and (2) you created the checkbox using the Control Toolbox:
There is a property for the checkbox called LinkedCell. Put a cell
reference, for example A2, then reference that cell in your formulas...
=if(A2=True,1,2)

 

[beurling]

Excellent

Thanks...

Assuming that (1) you have the checkbox directly on a worksheet and NOT on a
form and (2) you created the checkbox using the Control Toolbox:
There is a property for the checkbox called LinkedCell. Put a cell
reference, for example A2, then reference that cell in your formulas...
=if(A2=True,1,2)