| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Check Box
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. |
|
#2
|
|||
|
|||
|
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. gtcyberaz wrote: 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. -- Dave Peterson |
| 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) | |||
| Using a Check Box as a control item | 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) | |||
Linear Mode
