How to display add'l rows based on dropdown

Closed
alyssa - May 5, 2010 at 01:01 AM
rizvisa1
Posts
4479
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.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0