Home |
Search |
Today's Posts |
#1
|
|||
|
|||
check box
Im having trouble creating a checkbox in excel that if a user clicks it - a
check mark is made or removed. I created the box with active X - but I cant figure out what to change to make it functional. As a follow up - how can I take a box that is checked and use it in a formula. (ie if checkbox 1 is checked then A1+B1 if not "n/a" Thanks, Yosef |
#2
|
|||
|
|||
Yosef,
Take it out of design mode (upper left button of Controls Toolbox), and the check box should be functional. To be able to test it in a formula, first link the check box to a cell. Put it in design mode, right-click the check box, Properties, and set "Linked cell" to the cell you want. You'll get TRUE or FALSE. =IF(A1, "Checked", "Not checked") For a cleaner setup, name the cell, something like Box1. =IF( Box1, "Checked, "Not checked") -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "ynissel" wrote in message ... Im having trouble creating a checkbox in excel that if a user clicks it - a check mark is made or removed. I created the box with active X - but I cant figure out what to change to make it functional. As a follow up - how can I take a box that is checked and use it in a formula. (ie if checkbox 1 is checked then A1+B1 if not "n/a" Thanks, Yosef |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
check box formatting | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) |