Loading a Form Field Drop-Down

[Lloyd H. London]

I have been working on creating various forms and would like to load a
Form Field drop down from an Excel file. The Excel file currently
contains 744 entries, in one column and is subject to change regularly.
It would therefore be most convenient to be able to run code on entering
the field (or on opening the form) to read the Excel file and load the
data into the Form Field drop-down.
I assume the sequence of events would be to unprotect the form, call the
Excel file, load the data into the form field, and protect the form.
Does anyone have a suggestion on how to do this? Would be a great help,
as I could use this for many forms that we have.
I am not well versed in VBA, but with some ideas, I could have our
Excel, and Access developers look at this.
Thanks

 

[Cindy Meister -WordMVP-]

Hi Lloyd,

I have been working on creating various forms and would like to load a
Form Field drop down from an Excel file. The Excel file currently
contains 744 entries

I think at this point you have to stop and re-think. A form field
dropdown can only hold a maximum of 25 entries. Given this limitation,
you should probably consider a Text form field, where the ENTER macro
displays a UserForm with a VBA combobox or listbox.

You'll find information on how to pick up information from Excel on the
mvps.org/word website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail