Add a checkbox to a spreadsheet

B

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
 
G

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)
 
B

beurling

Excellent :)

Thanks...

Gary Brown said:
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)
Click to expand...
 

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

Similar Threads

How do I add a control check box to control other checkboxes? 1
Data Validation and drop-down list using IF, AND and what else? 8
Checkbox issue - Checkbox overlapping when filter is applied 1
autofit a checkbox to the appropriate cell 1
Beginner - Click a checkbox then calculation to be done automatically 1
Auto Assign Check boxes 10
Auto Assign Checkboxes in Excel 2007 2
Hiding a ComboBox with a Checkbox 2

Top