Function Help Needed

  • Thread starter Thread starter James
  • Start date Start date
J

James

Greetings;

I have a spreadsheet that I have put a check box on. If the box is
checked (TRUE), I want an function to be performed in another cell. If the
box is unchecked (FALSE), I want the value of the cell to just either be
blank or zero. I used the function dialog box and it took with no errors,
but nothing happens when I check the box. If I type the word 'TRUE' or
'FALSE' in the cell, the function works just fine. However, I want to use
the check box. How do I go about doing this? Many TIA!

James
 
Have you linked the check box to a cell where you have manually entered True
or False. When you link the checkbox, it will put true or false in the
cell it is linked to. You can then use this cell in your function.

If the checkbox is from the Control Toolbox Toolbar, then you would put the
sheet in design mode, using the upper left control in the Control toolbox
toolbar, then right click on the checkbox and select properties. In the
Linkedcell property, you would put in something like Sheet1!A1 (assume we
are on sheet1). Now get out and put the sheet back in normal mode by
clicking on the control in the upperleft corner of the control toolbox
toolbar so it doesn't appear depressed. True or false should appear in A1
(or the cell you specified).

If it is from the forms toolbar, right click on it and select format
control.
Go to the Control tab and in the Cell Link box, put in the reference to the
cell such as Sheet1!A1 or click in the box then navigate to the cell and
click in it. Now OK out of the box.
 
Back
Top