How to unhide rows in Excel form?

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?
 
S

Shane Devenshire

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
Hide rows that contain radio buttons 2
unable to unhide rows in excel 4
CommandButton used to hide and unhide rows 1
Cannot unhide the hidden rows in my spreadsheet 3
how do we establish different groups of radio button in excel 2
Questionnaire using Excel 3
Can't Unhide Rows in 'batches'! 3

Top