drop down box values from excel list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
How can i create a drop down box in Word 2000, in which I can get values
from an Excel list. Plz help!
Thanks
 
sallu said:
Hi!
How can i create a drop down box in Word 2000, in which I can get
values from an Excel list. Plz help!
Thanks
Click to expand...

The article at http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm
shows how to get the data from Excel.

What is assumed in the article, but not stated explicitly, is that it's
talking about loading the data into a listbox in a UserForm. This is not the
same as a dropdown in a protected form (from the Forms toolbar). The Forms
dropdown has a limit of 25 items, and each item is limited to 50 characters,
so you're probably better off with a UserForm anyway.

If you know nothing about UserForms, see
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm for a simple
tutorial.
 
Back
Top