Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Having a Drop-down list in Word referring to an Excel list Having a Drop-down list in Word referring to an Excel list
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-07-2016, 11:20 PM
gmayor's Avatar
gmayor gmayor is offline Having a Drop-down list in Word referring to an Excel list Windows 10 Having a Drop-down list in Word referring to an Excel list Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
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
Reply With Quote
 

Tags
drop down lists, excel list, word template

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having a Drop-down list in Word referring to an Excel list 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
Having a Drop-down list in Word referring to an Excel list (Excel 2007) Need help with colour change when condition met in drop down list oalrashdan Excel Programming 1 12-13-2013 02:21 AM
Having a Drop-down list in Word referring to an Excel list drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 PM.

Contact Us - Privacy Statement - Top

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