Microsoft Word Form Using Data From Excel

[Jackie]

Good Afternoon,

I have a form created in Microsoft Word 2003.

There are no macros or anything complicated, simple normal form fields
that the user tabs and types.

What the form needs is to a 'list box' or a 'drop-down box' where the
user selects from the descriptions provided.

Now the descriptions are currently in the form of an Excel file, 4
columns - 4,654 rows. Originally I thought I could link to pull the
data in - but have sense learned that is not an option.

I found this article:
http://groups.google.com/group/micr...general/browse_thread/thread/154fca8698009a6e

And this is what I am needing to do essentially. So I took the data
from Excel and put into a Word (*.doc) file.

I have zero VBA skills and possibly that is the reason I haven't been
able to get the code on the link to work.

I understand the copy/paste, that I got. I also understand when to
change the file names listed and input with my file names. Got that
too. But the VBA code 'command' and 'listbox' toss in 'initialize'
and I am screwed.

Ultimately I need a 'drop-down' box that allows my users to click and
the field populates the data that was selected. Sounds simple enough
but after two days of problems, I am going to the experts for
guidance.

I look forward to someone's help.

 

[Doug Robbins - Word MVP]

See the following pages of fellow MVP Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com

 

[Graham Mayor]

Are you expecting the user to pick from a list of 4654 items? That being the
case, I would have expected the user's eyes to glaze over long before (s)he
got to the bottom of the list. While I acknowledge that Doug has provided a
means of populating a list box in a user form from a data source, the
practicalities of selecting from such a monster list would seem to outweight
the benefits. Would it be possible to limit the number of items in the list
to make the selection a more practical proposition?

I was thinking of something along the lines of
http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm
http://www.gmayor.com/SelectFile.htm and (more sophisticated)
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>