Check Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Check Boxes 1
cell value based on combo box entry 9
Change formulas in a column based on a selection. 3
check and uncheck macro 5
Access Microsoft access database(creating a search engine form) 0
Duplicating check boxes with formulas 1
check box question 3
checkbox in a protected worksheet 2

Back
Top