Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 08-11-2022, 08:18 PM
shanshan89 shanshan89 is offline Import list from Excel into drop-down content control in word Windows 10 Import list from Excel into drop-down content control in word Office 2019
Novice
Import list from Excel into drop-down content control in word
 
Join Date: Jul 2022
Posts: 17
shanshan89 is on a distinguished road
Smile

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.
Attached Files
File Type: dotm EXAMPLE WITH 3 TABLES & 3 SIMPLE DROPDOWN LIST.dotm (76.8 KB, 9 views)
File Type: xlsx Excel Data Store.xlsx (9.1 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import list from Excel into drop-down content control in word How to import list from Excel into drop-down list into word ahw Word VBA 43 02-28-2020 08:11 PM
Import list from Excel into drop-down content control in word Assigning Macro to Drop Down list Content Control aussiew Word VBA 5 03-10-2019 02:55 PM
Import list from Excel into drop-down content control in word Export Word Drop-Down Content Control to Excel Specific Sheet nolanthomas32 Word VBA 4 09-19-2017 06:25 AM
Import list from Excel into drop-down content control in word 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.


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