I need some help with modifying an IF THEN ELSE (VBA) routine in MS Excel which validates that "required survey questions" have been answered.
Please see attached XLS... all details (e.g., problem and envisioned process flow) are included in the XLS.
I'd welcome any feedback on how the validation for "required survey question" routine can be modified so that the thrown dialogue boxes won't be a nuisance.
P.S. Please note that the actual survey has approximately 50 questions. If "nested IFs" are required, this could become an issue.
Thank you in advance!