How to unhide rows in Excel form?
 

I'm creating a questionnaire in Excel 2002 and I want to achieve the following:

Ask an initial question, via a form, where the user will answer by selecting a radio button.

Depending upon the radio button selected, I want to ask one or more questions but I don't want these questions to be visible until the original question has been answered.

How can this be done?

How to unhide rows in Excel form?
 

Hi,

Yes. You can change the size of the form in response to the
Optionbutton_Click event.

Private Sub OptionButton1_Click()
Me.Height = 200
End Sub

Private Sub OptionButton2_Click()
Me.Height = 100
End Sub

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MWL" wrote:

I'm creating a questionnaire in Excel 2002 and I want to achieve the following:

Ask an initial question, via a form, where the user will answer by selecting a radio button.

Depending upon the radio button selected, I want to ask one or more questions but I don't want these questions to be visible until the original question has been answered.

How can this be done?