|
|
#2
07-07-2016, 11:20 PM
|
||||
|
||||
You would need VBA to read the Worksheet into a userform list or combo box (or into an array).
The basics of userforms are covered at http://www.gmayor.com/Userform.htm where you will also find an example template. Example code for filling a userform list of combo box is shown at http://www.gmayor.com/Userform_ComboBox.html. Virtually instantaneously, this reads the worksheet into the list and so can be applied any time you open the userform and it will always show the last saved version of the data. Arrays you can discover another day.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com 
|
| Tags |
| drop down lists, excel list, word template |
| Thread Tools | |
| Display Modes | |
|
|
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 |
| Microsoft Excel, Drop Down List | Phibir | Excel | 1 | 04-16-2015 01:01 PM |
| Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
|
(Excel 2007) Need help with colour change when condition met in drop down list
|
oalrashdan | Excel Programming | 1 | 12-13-2013 02:21 AM |
|
drop down list from external data source Excel 2007?
|
Intruder | Excel | 1 | 08-03-2012 05:41 AM |
Windows 10 
Office 2016
Threaded Mode