Previous Topic Next Topic

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
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Computer turns on but no display
Lancenz -
Lancenz -

2 responses