Detixtwinings
New Member
- Joined
- Feb 26, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Currently I have created two questionnaires on excel on the same sheet, one below another. However, I want that when the user opens the excel, questionnaire 2 (rows 87-179) is hidden, until they have completed questionnaire one and satisfying certain criteria.
The first questionnaire has 20 questions and all of them have a yes or no options button (form control) for the user to select. The criteria to unhide questionnaire 2 (rows 87-179) are:
User selects 'Yes' for any one of the follow questions:
8, 9, 10, 11, 12, 18 or 19
AND question 14 must always be 'No' in order for the questionnaire 2 to be unhide.
I have looked through so many forums for an answer but nothing works. I'm new to vba.
Thanks!
The first questionnaire has 20 questions and all of them have a yes or no options button (form control) for the user to select. The criteria to unhide questionnaire 2 (rows 87-179) are:
User selects 'Yes' for any one of the follow questions:
8, 9, 10, 11, 12, 18 or 19
AND question 14 must always be 'No' in order for the questionnaire 2 to be unhide.
I have looked through so many forums for an answer but nothing works. I'm new to vba.
Thanks!