![]() |
|
#9
|
|||
|
|||
|
Hi!
I have uploaded the dotm word file and the excel where the data for the simple word dropdown list is stored. As mentioned, I have 3 identical tables. For each table under column 3, I have a simple dropdown list. The user has the flexibility to delete any of the tables depending on whether he needs the table. However, when any of the tables are deleted, there will be an error "Run-time error '5941':The requested member of the collection does not exist". Hence I was wondering, if there is any way to modify the code such that if e.g. Dropdown List 1 or Dropdown List 2 or Dropdown List 3 does not exist, ignore and go to the next line of code. I think it's similar to Python's "try, except, pass" method but I don't know how to write it on word VBA. I tried to add "On Error Resume Next" to my word VBA code but it doesn't work. Hope this clarifies! Thanks. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word
|
ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Assigning Macro to Drop Down list Content Control
|
aussiew | Word VBA | 5 | 03-10-2019 02:55 PM |
Export Word Drop-Down Content Control to Excel Specific Sheet
|
nolanthomas32 | Word VBA | 4 | 09-19-2017 06:25 AM |
How to get a Drop Down List Content Control box to fill in other areas
|
snips1982 | Word | 2 | 03-22-2017 03:37 AM |
| Word 2010 Content Control help - Combo Boxes vs Drop Down List | proghy | Word | 1 | 09-16-2014 02:01 PM |