Add a checkbox to a spreadsheet
 

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

Add a checkbox to a spreadsheet
 

Excellent :)

Thanks...

"Gary Brown" wrote:

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)
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"beurling" wrote:

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