How to make hidden rows in Excel reappear when a Radio Button sele
 

I'm creating a questionnaire in Excel 2002 and one of the things I want to do
is, for example, ask a question which has a Yes/No answer. The user will
choose a radio button to select their answer.

Based on their response, if the answer is, for example, Yes, I then want
more question to appear.

How can this be done?