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

I figured out the issue thank you. 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Crating User Form to Add Names 1
Dynamic Naming of Form Button 3
How to create skip pattern in access 2013 form 0
VBA Help with Form 1
how to Hide/reappear label & check boxes 0
Page numbering with Merged Document and IF statements 1

Top