How to display add'l rows based on dropdown
Closed
alyssa
-
May 5, 2010 at 01:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2010 at 05:50 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2010 at 05:50 AM
Hi,
I am trying to create a template with a series of questions with responses of Yes or No. A Yes answer would require further information. If the answer is No, there are no further information required. The additional information is not defined (will vary and contain text/paragraphs), therefore I need to allot a number of rows.
I have created a drop down list for Yes or No already but what I don't know is how to trigger the insert/display of the additional rows if the answer is Yes.
What is the best way to do this? Thanks a lot in advance.
I am trying to create a template with a series of questions with responses of Yes or No. A Yes answer would require further information. If the answer is No, there are no further information required. The additional information is not defined (will vary and contain text/paragraphs), therefore I need to allot a number of rows.
I have created a drop down list for Yes or No already but what I don't know is how to trigger the insert/display of the additional rows if the answer is Yes.
What is the best way to do this? Thanks a lot in advance.
Related:
- How to display add'l rows based on dropdown
- Huawei display check code - Guide
- Computer turns on but no display on monitor - Guide
- To display a text file in reverse order what command should be used - Guide
- Download mp3 with lyrics display - Download - Audio playback
- Instagram account based in wrong country - Instagram Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2010 at 05:50 AM
May 5, 2010 at 05:50 AM
Most probably you have to define this routine
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
This routine has to be defined in the sheet where you want this to occur. So go to VBE by pressing ALT + F11 and there double click on the sheet where you had defined this dropdown
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
This routine has to be defined in the sheet where you want this to occur. So go to VBE by pressing ALT + F11 and there double click on the sheet where you had defined this dropdown
