Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a checkbox to change a formula
hi all
I have a checkbox, cbxUseNewSystem on my worksheet. When the box is checked, I need to have a long CSE formula in cells G10:G30. Without the boring details, its structure is: {=IF(code here) & IF(more code here) & IF(even more code here)} If the checkbox is NOT checked, the CSE formula in G10:G30 needs to be the same as above, but with the last IF removed, like: {=IF(code here) & IF(more code here)} I'm just learning code, and I'm a bit confused as to how to do this? Any help will be appreciated. Giselle |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a checkbox to change a formula
Did you assign a linked cell to that checkbox? If yes, you can use:
=if(code)&if(morecode)&if(linkedcell=true,morecode ,"") Depending on what checkbox you used, you assign that linked cell differently. From the Forms toolbar--rightclick on it and choose format control|control tab. From the Control Toolbox toolbar--click on the design mode icon on that same toolbar and right click on the checkbox and choose properties. Giselle wrote: hi all I have a checkbox, cbxUseNewSystem on my worksheet. When the box is checked, I need to have a long CSE formula in cells G10:G30. Without the boring details, its structure is: {=IF(code here) & IF(more code here) & IF(even more code here)} If the checkbox is NOT checked, the CSE formula in G10:G30 needs to be the same as above, but with the last IF removed, like: {=IF(code here) & IF(more code here)} I'm just learning code, and I'm a bit confused as to how to do this? Any help will be appreciated. Giselle -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change the value of a cell with a checkbox | Excel Worksheet Functions | |||
How do I change the appearance of a checkbox | Excel Discussion (Misc queries) | |||
how do I make checkbox color change when the value changes? | Excel Discussion (Misc queries) | |||
CheckBox Change Event | Excel Programming | |||
Trigger an event on Checkbox change | Excel Programming |