Hi all

Is there a way to set a conditional formula based on a check box created thru the developer tool box

I would like to creat a work sheet that has ( 6 ) check boxes
When the check box is checked it call for a formula set
When it is unchecked it calls for a different formula set

Each formula set would contain a minimum of ( 2 ) formulas

Example
Check Box #1 = ( X )
When Check Box ( X ) is checked it uses formula set (A1)
Formula set (A1) has formula (a1) & (a2)
When Check Box ( X ) is unchecked it uses formula set (A2)
Formula set (A2) has formula (a3) & (a4)

Check Box #2 = ( Y )
When Check Box ( Y ) is checked it uses formula set (B1)
Formula set (B1) has formula (b1) & (b2)
When Check Box ( Y ) is unchecked it uses formula set (B2)
Formula set (B2) has formula (b3) & (b4)

Any Help on this issue would be greatly appreciated

Thanks in advance for the help

Bradley Wolosz

Can you be more specific? What *exactly* would these formulas do?

If you link the check box to a cell then it's fairly simple to base a
formula on whether the check box is checked or not checked. When a check box
is checked the linkd cell returns TRUE and when the check box is not checked
the linked cell returns FALSE. So, you can use a formula like this:

linked cell = A1

=IF(A1,use_this_formula,use that_formula)

--
Biff
Microsoft Excel MVP


"Brad Wolosz" wrote in message
...

Hi all

Is there a way to set a conditional formula based on a check box
created thru the developer tool box

I would like to creat a work sheet that has ( 6 ) check boxes
When the check box is checked it call for a formula set
When it is unchecked it calls for a different formula set

Each formula set would contain a minimum of ( 2 ) formulas

Example
Check Box #1 = ( X )
When Check Box ( X ) is checked it uses formula set (A1)
Formula set (A1) has formula (a1) & (a2)
When Check Box ( X ) is unchecked it uses formula set (A2)
Formula set (A2) has formula (a3) & (a4)

Check Box #2 = ( Y )
When Check Box ( Y ) is checked it uses formula set (B1)
Formula set (B1) has formula (b1) & (b2)
When Check Box ( Y ) is unchecked it uses formula set (B2)
Formula set (B2) has formula (b3) & (b4)

Any Help on this issue would be greatly appreciated

Thanks in advance for the help

Bradley Wolosz




--
Brad Wolosz