Improve userform using vba

**stewfeed** · 04-03-2013, 11:22 PM

Hi. I created a survey form using excel. But I will be very much pleased about it being fine-tuned for better administering of the survey and easier management of data results. I hope it will be modified according to the following conditions:

1. Multiple answers for each case is not allowed. That is, if the user chose ANSWER D for instance, then he/she will not be allowed to mark another answer altogether.
2. If ANSWER U is marked, user will be required to fill out columns U1 and U2.
3. User will not be able to close the excel form if not all cases have been completely answered. Likewise in the case where User chose ANSWER U, he/she will not be able to close it until columns for U1 and U2 have been filled out.
4. The form will be reproduced with completely different number of cases each copy (some can even reach up to more than 2,000), so I was hoping that the form will not be limited by the number of rows defined in the sample excel form.

**kcarley** · 04-08-2013, 05:06 PM

Hi, this seems to work well and within your requirements too. To handle the "no missing answers" requirement I did add one column; I hope that will work for you. I would also recommend that you fill your combobox list in the validation itself or via code, they tend to get changed accidently when they are part of the sheet being used like this.

excel help (04032013).xlsm

Anyone that happens to "like" the results provided here should feel encouraged to click the star in the bottom left corner of this post to add to my reputation.

Cheers!