Hello all,
I am trying to write VBA code that will show or hide subsequent questions based on the answer to a prior question.
As an example:
"Do you prefer?" "blue" or "red" (in a drop down)
If I answer "blue" I see the 2nd row which has the question "Do you prefer?" "dark blue" or "light blue" (in a drop down)
If I answer "red" I see the third row (the second is hidden) which has the question "Do you prefer?" "dark red" or "light red" (in a drop down)
The code I have written to do this doesn't work. Any suggestions are welcome. Thanks in advance
I am trying to write VBA code that will show or hide subsequent questions based on the answer to a prior question.
As an example:
"Do you prefer?" "blue" or "red" (in a drop down)
If I answer "blue" I see the 2nd row which has the question "Do you prefer?" "dark blue" or "light blue" (in a drop down)
If I answer "red" I see the third row (the second is hidden) which has the question "Do you prefer?" "dark red" or "light red" (in a drop down)
The code I have written to do this doesn't work. Any suggestions are welcome. Thanks in advance
Last edited: