Check Box

G

gtcyberaz

In excel can I have a specific value assigned to a cell when a corresponding
check box is marked. In summary if is click on an ActiveX checkbox I want
the number "3" to appear in a cell just to the right of the checkbox.
 
D

Dave Peterson

Assign a linked cell to that checkbox (I used A1).

Then use that linked cell in a formula:
=IF(A1=TRUE,3,"not checked")

I like to use a column right near the checkbox--but I'll hide that column to
make things prettier.
 

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
Populate a table based on check box status 2
Anything will help 0
Word OLE to check spelling in text box 1
Check Boxes 1
Resource Budget Cost - Tracking 0
How to create bulleted to-do list using two styles? 5
list or combo box 0

Top