M MWL Feb 12, 2009 #1 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?
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 Feb 12, 2009 #2 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
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
