How to unhide rows in Excel form?

  • Thread starter Thread starter MWL
  • Start date Start date
M

MWL

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.
Click to expand...
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.
Click to expand...

How can this be done?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Radio Buttons 3
Tick boxes in excel 2
Hide rows that contain radio buttons 2
Radio Button Macro 3
Unhide a row 1
Questionnaire using Excel 3
Is it possible to hide column headings & row numbers? 2
Hide Unhide Buttons 3

Back
Top