How to populate a drop-down list in Word with an Excel list?
HTML-код
- Опубликовано: 8 июл 2024
- 🚨 ALL INFORMATION IN DESCRIPTION (CLICK ON "MORE") 🚨
#TutoWord #WordVBA #Word #MSWord
🙋 Join the Votre Assistante Facebook group to share tips and tricks around #Word, #Excel, #Access, #PowerPoint, #VBA, #Photoshop and #Illustrator software: / votreassistante
⚠️ To better view the video, I advise you to set the quality of the video to HD by clicking on the toothed wheel (↓ at the bottom right → of the video). ⚠️
📢 To be informed of the publication of future articles, subscribe to the newsletter and receive the checklist for creating a professional report with Word: formations.votreassistante.ne...
🚨 Subscribe to the channel by clicking on Subscribe (just above ↑) then on the 🔔 next to not miss any video 😉
Tutorial made with Word Microsoft 365
Video tutorial to learn how to feed a drop-down list in Word with an Excel list automatically with VBA.
🔗 To access the text version of this tutorial, go to Votre Assistante: www.votreassistante.net/comme...
☑️ Useful links:
- www.votreassistante.net/creer...
- www.votreassistante.net/pourq...
- formations.votreassistante.ne...
📖 Summary:
00:00 Introduction
00:28 1. Presentation of the files used
00:57 2. Setting the Excel range name
02:14 3. Showing the Developer menu in Word
02:37 4. Creating the drop-down lists that we are going to populate
05:03 5. Populating a drop-down list in Word with an Excel list
05:20 5.1. Creation of the procedure for populating the drop-down lists when opening the Word file
06:37 5.2. Declaration and definition of variables common to the three types of Word controls
11:32 5.3. Populating a drop-down list content control on Word (Windows)
15:06 5.4. Populating a drop-down list from a legacy form control on Word (Windows and Mac)
17:012 5.5. Populating a drop-down list of an ActiveX control on Word (Windows)
18:39 6. Opening the file to run the macro
🚀 To go further, discover everything you need to know to quickly create summaries with Word: www.votreassistante.net/forma...