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
|