Checkbox Control - How to display a true or false value in the cellcontaining a checkbox

D

Dave K

How can i display a True value in a cell if a checkbox control is
checked (and false value if it is unchecked). Thanks for any
suggestions.
 
D

Dave Peterson

There are two checkboxes in Excel.

One is from the Forms toolbar and the other is from the Control Toolbox toolbar.

If your checkbox is from the Forms toolbar, then rightclick on the checkbox and
choose "Format Control".

Then on the Control tab, type in the address of this cell.

If your checkbox is from the Control toolbox toolbar, then go into Design mode
(another icon on that toolbar), rightclick on the checkbox, choose Properties
and look for LinkedCell. Type in the address for that cell.

Make sure you leave design mode when you're done making your change.
 

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

checkbox problem 22
CheckBox 1
Dynamically assign macro 23
Data Validation and drop-down list using IF, AND and what else? 8
Auto Assign Check boxes 10
Checkbox background pattern problem 1
delete a checkbox 4
Create a Fuctioning Checkbox 4

Top