View Single Post
 
Old 10-20-2014, 04:55 AM
tejaspareek tejaspareek is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2014
Posts: 13
tejaspareek is on a distinguished road
Default Delete Tables using conditions from Drop Down Field

Hi,

I was trying to work on a Word Document.
I have created various dropdown fields in the form.
I need a functionality to delete specific tables when a certain dropdown is selected.

For example:
I have a dropdown field which is named "Parent1" and the dropdown options are Yes and No.
I want to delete tables 10 to 14 if the option "No" is selected.

I have entered the following code but it is only accepting one condition.

Sub Parent()
ActiveDocument.Unprotect
Select Case ActiveDocument.FormFields("Parent1").Result
Case "No": ActiveDocument.Tables(10).Delete
End Select
ActiveDocument.Protect wdAllowOnlyFormFields, True
End Sub



But this code can delete only 1 table.
I am new to VBA, need help.
Reply With Quote