I'm creating a questionnaire in Excel 2002 whereby Row 8 Column B contains
the first question.

The user then has a choice of 3 answers and they have to select the
appropriate check box to select their answer.

However, what I want to do is depending on the answer selected, I want the
user to answer more questions, but I want these questions hidden from view
until they are required (e.g. If user selects check box for answer A to
question 1, I want more questions to appear relating to answer A.

How can this be done?