| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you assess the state of a form-checkbox in a logic statemen
Can anyone give an example of accessing the logic state of a form-checkbox
(true-false) for use in an IF statement? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you assess the state of a form-checkbox in a logic statemen
Whatever cell the checkbox is linked to can be used in your IF statement.
If the checkbox is tied to say cell a1, in another cell if you put "=if(a1=true,"Happy","Sad")" (without quotes) as you check and uncheck the box the other cell will change from Happy to Sad. Squeaky "jvatlanta" wrote: Can anyone give an example of accessing the logic state of a form-checkbox (true-false) for use in an IF statement? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear a Checkbox in a a user form | Excel Discussion (Misc queries) | |||
| Form CheckBox font size / style | Excel Discussion (Misc queries) | |||
| How do I setup a cell in Excel as a checkbox w/o a form/activex c. | Excel Discussion (Misc queries) | |||
| How do I make a checkbox bigger in an excel form? | Excel Discussion (Misc queries) | |||
| add size option to excel form checkbox | Excel Discussion (Misc queries) | |||
Hybrid Mode
