I'm trying to create a base to use for some simple calculations in excel. I'm not a professional user so my coding skills are very limited. Here is a couple of questions:
1) I have some tables, where it would be cool to have a feature to check boxes for values I use in calculations. However, I have problems using check boxes and option buttons in formulas. Is there any clever way to do this? For an example, I use check boxes and option buttons to pick a value and use that value later on in formula to summarize it with other values.
2) How do I group option buttons to separate questions? I have several questions which require option buttons, but now it acts like I had only one choice between all of my questions.