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

Create form with checkbox les that expand and collapse sections of the form? 0
Anything will help 0
Word macro that can call cells out of Excel for a find and replace 0
Generated text copies into another template 0
Change a great number of words in word files, with a macro as short as possible. 5
checkbox problem 22
How to correct a #N/A in vlookup 1
Data Validation and drop-down list using IF, AND and what else? 8

Top