Checkbox question.

[thewiseguy]

Hi everyone,

I am creating a worksheet which will detail 3 options for my sales reps to use for putting together a business proposal. Each option has a number of factors (i.e cost, margin, labor etc). Is there a way for the checkbox to work as an "activator" so that if I choose Option 2, the data in Option 2 will get moved to a highlighted area?

 

[Joe Was]

You can do it a few ways in VBA and at least one way using formulas.

Need more information, like, which type of checkboxs you are using and where the information is now and where you want it after a box is checked.

You can make the variable data portion dependent upon the value of the checkbox, nesting all three of the checkboxs in an if statement, so that cell will only show information, if one of the checkboxs is checked. Then re-do this for each of the cells that get this variable information.


See here:

http://www.mrexcel.com/board2/viewtopic.php?t=255691