Excel Excel 2003 Macro

[napierchris]

Hi everyone,

I am looking for a macro for check boxes. Here is the scenario. I have four check boxes which are grouped together. The boxes represent ingredients in a cake. When the box is checked the ingredient is present, when it is not, it is not present. The cakes have a frozen, refrigerated and ambient shelf life. Those values will be available elsewhere in the work book, probably on another sheet. The shelf life is directly affected by which ingredients are present. How do I write a code that will output the shelf life values based on which boxes are checked?

I'm assuming I need to take into consideration all possibilities, for example, if box1 is selected do this, if box1 and box3 are selected do this, and so on and so forth. There will be no else statements as every scenario should be covered.

In addition, there will be multiple cakes with different ingredients and different shelf lives. Can I assign the same macro to each group of four check boxes?

Any input is appreciated.

Thanks,
Chris