Assigning values to a category for statistical analysis

[Shuja Ali]

For example you have 4 options for each category. Now User select number 1 for first, number 3 for 2nd question, etc then you have a button Submit on your form. In the submit button's click event handler, you can do the calculation using simple if or Select Case statements. Show us what have you written so far?