Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make a checkbox create a value?
I am setting up a sheet wherein I want a value to appear when I place a check
in a checkbox. Example: I want to check the box that I have placed in cell L18 and have a numeric value (5 or 10) appear on cell O18. How can I do this? |
#2
|
|||
|
|||
Right-click on your Check box and select Properties.
Set the Linked cell to whatever cell you would like (L18). This cell will display "True" if the box is checked, and "False" if it is not. Cell O18 could have a formula in it such as: =IF(L18=TRUE,5,10) HTH, Paul "cookin_dad" wrote in message ... I am setting up a sheet wherein I want a value to appear when I place a check in a checkbox. Example: I want to check the box that I have placed in cell L18 and have a numeric value (5 or 10) appear on cell O18. How can I do this? |
#3
|
|||
|
|||
Maybe I created the checkbox using the wrong procedure - I added it using the
Form Objects; when I right-click on it, I dont have properties. Should I have created it using another method? "PCLIVE" wrote: Right-click on your Check box and select Properties. Set the Linked cell to whatever cell you would like (L18). This cell will display "True" if the box is checked, and "False" if it is not. Cell O18 could have a formula in it such as: =IF(L18=TRUE,5,10) HTH, Paul "cookin_dad" wrote in message ... I am setting up a sheet wherein I want a value to appear when I place a check in a checkbox. Example: I want to check the box that I have placed in cell L18 and have a numeric value (5 or 10) appear on cell O18. How can I do this? |
#4
|
|||
|
|||
Use the 'Control Toolbox' to create your checkbox.
Go to 'View-Toolbars-Control Toolbox'. Pau; "cookin_dad" wrote in message ... Maybe I created the checkbox using the wrong procedure - I added it using the Form Objects; when I right-click on it, I dont have properties. Should I have created it using another method? "PCLIVE" wrote: Right-click on your Check box and select Properties. Set the Linked cell to whatever cell you would like (L18). This cell will display "True" if the box is checked, and "False" if it is not. Cell O18 could have a formula in it such as: =IF(L18=TRUE,5,10) HTH, Paul "cookin_dad" wrote in message ... I am setting up a sheet wherein I want a value to appear when I place a check in a checkbox. Example: I want to check the box that I have placed in cell L18 and have a numeric value (5 or 10) appear on cell O18. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i can make checkbox on Ms. Excel? | Excel Discussion (Misc queries) | |||
how i can make checkbox on Ms. Excel? | Excel Discussion (Misc queries) | |||
How do I make a checkbox bigger? | Excel Discussion (Misc queries) | |||
Checkbox formatting.. anyway to make the checks bold or standout m | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions |