Can populate MS Word field codes with excel list?

Question

Hello. I am making a word sheet with a drop down list of violations (1.1, 1.2, etc.) | have my drop down bookmarked as violations. At the moment I have been using {IF{REF Violation}="1.1" "violation text"}. Now I have 71 violations. Is there a way I can populate this faster rather than one by one? I know if I simply type {} it won't work. U have to CTRL + F9. I have all violations with code listed in A and B columns. Any help would be appreciated.

Answer 1

It is possible to do this with some macro programming. The solution is described at https://gregmaxey.com/word_tip_pages/import_excel_list_into_word_dropdownlist.html

Answer 2

Hi @bubbykong

Thank you for contacting Microsoft Q&A Support.

You can use a VBA macro in Word to read your Excel list (with violation codes and descriptions) and automatically generate the IF fields for you.

Step 1: Enable the Developer tab in Word

• Go to File > Options
• Select Customize Ribbon
• On the right side, check the box for Developer
• Click OK
• 

Step 2: Open the VBA Editor 

• Press Alt + F11 to open the Visual Basic for Applications editor 
• Or go to the Developer tab and click Visual Basic 

Step 3: Insert a new module 

• In the VBA editor, go to Insert > Module 
• A blank code window will appear 

Step 4: Paste the macro code 

You can also follow this official Microsoft tutorial to get started with VBA in Office: Getting started with VBA in Office | Microsoft Learn 

If you need any further assistance or have additional questions, please don’t hesitate to reach out. I'm here to help. 

Thank you again for your patience and for choosing Microsoft Q&A forum. 

 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.