| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
drop down box values from excel list
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 |
|
#2
|
|||
|
|||
|
sallu wrote:
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 The article at http://word.mvps.org/FAQs/InterDev/F...xFromXLDAO.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. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merged in word w/ address list in excel, now cant open excel | Mailmerge | |||
| Help I am going crazy I am trying to merge a label list excel to w | Microsoft Word Help | |||
| drop down list | Microsoft Word Help | |||
| How do I add more than 25 lines to a drop down list? | Microsoft Word Help | |||
| How to update 2003 Word Doc for 2004 with Excel list | Microsoft Word Help | |||
Linear Mode
