Juicey27
09-09-2010, 05:01 AM
Excel 2007 - VBA - Userform
One Answer per Question : Checkboxes
I have a userform with 8 questions, 3 checkboxes for each question, and a total of 24 checkboxes. For each question the three available checkbox choices are YES, NO, N/A. (Please see attachment.) Is there a way so that when selecting the answer, an individual is only able to select one of the three checkboxes per question? For example: On question one > if I select "YES" as my answer then i want the userform to prevent me from being able to also select either "no" or "n/a" for that same question. This way I can ensure that only one answer is selected/submitted per question. Any suggestions are welcome!!
(Please see attachment.)
One Answer per Question : Checkboxes
I have a userform with 8 questions, 3 checkboxes for each question, and a total of 24 checkboxes. For each question the three available checkbox choices are YES, NO, N/A. (Please see attachment.) Is there a way so that when selecting the answer, an individual is only able to select one of the three checkboxes per question? For example: On question one > if I select "YES" as my answer then i want the userform to prevent me from being able to also select either "no" or "n/a" for that same question. This way I can ensure that only one answer is selected/submitted per question. Any suggestions are welcome!!
(Please see attachment.)