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