Drop Down List

L

Lynda

I just read formformer's request on the drop down list choice populating other fields. Sorry I cannot help you with your problem, however, would you be able to tell me how you put 150 entries into the drop down list? I get a message that it only holds 25 items. Any suggestions on how to get more entries into the field or (ideally) am I able to cut & paste a list into the drop down?
Thanks Lynda
 
J

Jay Freedman

Hi, Lynda,

The dropdown list that's available on the Forms toolbar is absolutely
limited to 25 items (and, IIRC, 50 characters per item). To get a more
capable control, you need to use either the combobox control on the Control
Toolbox toolbar or a dropdown list in a Userform. Both of these alternatives
require VBA coding to load the entries into the list. See
http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm to get started.
 
D

Docs m.d.

I too am trying to create a drop down form list of > 25 items. Linda, if you are successful in your endeavor, please post and I'll do the same.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top