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

Brad,

You would like this to be a Formula, such that you could enter into a cell
.... similar to =SUM(). If so, I dont believe that you can do this. However,
you are able to place VBA scripting against the check box, to evaluate
whether it is checked or not and have a script run the formulas.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Brad Wolosz" wrote:


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




--
Brad Wolosz

Hi,

Among many possibilities, you could have a table, designed in a
separate area, where all the cases are listed and repective
calculations performed ...

Then, based on the checkboxes, just have a vlookup(yourtable) to bring
back the adequate result ...

HTH