Hide/Unhide Rows based on column data using checkbox

I have a questionnaire that I am developing that will require additional questions based on the group. There are standard questions that are visible when questionnaire is opened. I want to use check box to add additional questions for that that group (Group A). I want to use a check box for to add questions and hide some of the standard questions for that group (Group B).

I have read some of the threads and did not see a solution to my specific need.

I need to insure that macros hide or unhide the right rows when I need to add additional question rows.

Attached file is a test example. The actual questionnaire will have over 200 lines and over 20 possible groups or scenarios.

Thank you for any assistance that can be provided.

Rick

It may be easiest to have an unique identify of the rows you want to hide and unhide for Group B, and so on.

But this is some code that will just look at "Question" and Toggle the Row Hidden attribute between True and False. It should help you get started and is set for the fixed range of questions. But that can be modified to look down the sheet to the last row/question as needed.

Please Login or Register  to view this content.

or like sheet2


Kind regards
Leo