Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 08-23-2022, 01:41 AM
JakeD JakeD is offline VBA content control on exit delete rows Windows 11 VBA content control on exit delete rows Office 2016
Novice
VBA content control on exit delete rows
 
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)
  #2  
Old 08-23-2022, 03:38 PM
macropod's Avatar
macropod macropod is offline VBA content control on exit delete rows Windows 10 VBA content control on exit delete rows Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Duplicate of: https://www.msofficeforums.com/word-...trol-exit.html
Kindly don't post the same question in multiple threads. Thread closed. You may continue the discussion in your other thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA content control on exit delete rows Help please adding a macro to add a table row to a content control table on exit graw76 Word Tables 1 03-26-2021 03:37 PM
VBA Adding Rows To Table With Content Control lord_kaiser Word VBA 2 08-01-2020 01:01 AM
Delete Hidden content control Saul Word VBA 2 10-10-2019 11:49 AM
VBA content control on exit delete rows Delete rows with content controls baes10 Word VBA 2 12-13-2017 10:12 AM
VBA content control on exit delete rows VBA error Content Control On Exit jec1 Word VBA 5 08-16-2014 08:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft