VBA content control on exit delete rows
Good morning,
First time post so please forgive me if it is in the wrong place.
I have a document which has tables, each table having several rows and two columns. The first question in each table is a yes/no answer using a drop down combo box in the right column.
Is there a way to delete all rows under the first row if the question answer is 'no' using a macro based on content control exit?
I have uploaded an example which appears similar to my document. In my document I already have content control on exit for dropdowns tagged as RP which format the cell background colour.
Thanks
|