How to display add'l rows based on dropdown [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!