Drop down menu for 100 items & Autocomplete

[Debbiedo]

I am trying to design a protected MS Word 2003 template. Data from
this form will eventually be imported into Access. One of the fields
will be used to do a join on a look up table in Access so the
information inputted into the word document must be standardized.

I figure I will have to create a drop down list to accomplish this.
The problem is that the list has about 100 items. I would like the
user to add the first few letters and have it autocomplete the item in
the list and populate the field with this.

From what I have read the Word drop down list option can handle only

25 items. What do I need to do to make a list of 100 items and how do
I get it to use autocomplete? This form will be on over 20 separate
computers.

Suggestions anyone? Thank you in advance.

Deb

 

[Doug Robbins - Word MVP]

Well, you can use the method in the Knowledge Base Article:

WD2000: How to Create Combo Box with More Than 25 Items [Q198561]
http://support.microsoft.com/support/kb/articles/Q198/5/61.ASP

but as the involves the use of a userform anyway, you may as well start and
do it right with a userform.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and take a look at:

http://www.mousetrax.com/techpage.html#autoforms


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Mark]

1. could not find the link to start a new topic.
2. Started with http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
have runtime error 424: object required.
debubber stops at – UserForm1.show
Code:
Sub AutoNew()
UserForm1.Show vbModal
Unload UserForm1
Set UserForm1 = Nothing
'''
End Sub
3. purpose of program is to make labels from a avery form. Unit model and serial number are printed. I forsee many more problems before I get this to work.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Jay Freedman]

Unfortunately, the VBA debugger always stops on the .Show statement when
there's a syntax error in the userform being called. Post the code from your
userform so we can have a look.

From experience, the problem in userforms made from that article is usually
that you've left out the required space before the line-continuation
underscores in step 10. In other words, you must type a space between the
'e' and the underscore to change

.Bookmarks("Text1").Range_

to

.Bookmarks("Text1").Range _

See http://word.mvps.org/FAQs/MacrosVBA/_AtEndOfLine.htm for explanation.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.