Using a Lookup function to populate a combo box in a MS Word Form

[TonyK]

Hi
I am looking for a solution that will allow a list of options to be
displayed in a combo box from an external source such as a spreadsheet. The
issue I have is a combo box can only store a maximum of 25 entries. The
number of options I have are way in excess of that figure.
Any help/advice would be appreciated.
TonyK

 

[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


--
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

 

[TonyK]

Hi Doug
Many thanks for the prompt response. However I am using MS Word Online
Forms and it needs to be as simple as possible to maintain as I am an interim
and will be moving on shortly. I want to be able to leave the solution for
others to use and maintain. They have minimal knowledge of MS Word. Hence
my choice to use Online Forms.
Look forward to hearing from you.
TonyK

 

[Greg Maxey]

Tony,

The blunt truth is that "simple as possible" is a relative term. There is a
quip that goes something like: "You can't put 10 pounds of crap in a 5
pound sack. It simply can't be done." Same applies to a online form
combobox. Another alternative is shown here:
http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm, but like the
others it may not appear very simple.

 

[TonyK]

Hi Greg
Many thanks for the feedback.
TonyK

Tony,

The blunt truth is that "simple as possible" is a relative term. There is a
quip that goes something like: "You can't put 10 pounds of crap in a 5
pound sack. It simply can't be done." Same applies to a online form
combobox. Another alternative is shown here:
http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm, but like the
others it may not appear very simple.