Hi All

Is it possible to have excel pick a formula based on the value of a check box

I would like to create a worksheet with 6 check boxes for the developers tool box.
Each check box would pick one of two formula sets. Each formula set would contain two formulas. Each check box would contain a different cell set

Example


Check Box #1
if check box "X" is checked exicute formula set (1A)
Formula set (1A) includes formulas (1a) & (2a)
if check box "X" is not checked exicute formula set (2A)
Formula set (2A) includes formulas (3a) & (4a)
Check Box #2
if check box "Y" is checked exicute formula set (1B)
Formula set (1B) includes formulas (1b) & (2b)
if check box "Y" is not checked exicute formula set (2B)
Formula set (2B) includes formulas (3b) & (4b)

and so on for each check box

Any and all help would be greatly appreciated

Thank You

Bradley Wolosz