View Single Post
 
Old 08-23-2022, 01:41 AM
JakeD JakeD is offline Windows 11 Office 2016
Novice
 
Join Date: Aug 2022
Posts: 2
JakeD is on a distinguished road
Default 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
Attached Files
File Type: docm Example.docm (20.8 KB, 4 views)