Check boxes need to return a number

  • Thread starter Thread starter edrachel
  • Start date Start date
E

edrachel

Hi, I have not done anything with check boxes before, so I am reall
new at this. I am trying to do a sheet that will have check boxes tha
when checked will return a number from another sheet. When the box i
not checked, it should return a "0". If I just use a check column,
don't have any problems with the formula to pull the number from th
other sheet when you put an "x" in the column but I would like to us
check boxes or buttons. I will be sharing this will peers and woul
like to just make it a simple click. I have attached a copy of what
have completed. Only the first two lines are done but it should giv
you an idea of what I am trying to do. Any help will be appreciated.
Thanks

Attachment filename: quality analysis.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64640
 
I didn't open your attachment, but you could use your checkbox and its
linkedcell and a formula in a helper cell.

There are two different types of checkboxes--one from the Forms toolbar and one
from the Control Toolbox toolbar.

If you used the checkbox from the Forms toolbar:
right click on it and choose Format Control
then Control Tab
Give it a nice cell link (in a hidden column/row???)
(I'm gonna use A1 for my example)

then in another cell:
=if(a1=true,sheet2!b9,0)

===
It's just slightly different for the checkbox from the control toolbox toolbar.
Show the control toolbox toolbar
click on the "design mode" icon
rightclick on the checkbox and choose properties.
scroll down to Linkedcell and type in the address of the cell
(I'm using A2 for this example)

Then toggle the "design mode" icon (turning it off).

Then in the helper cell:
=IF(A2=TRUE,Sheet2!C9,0)

(a very similar formula)
 
Back
Top