Getting around 25 item dropdown limitation

[Lenny]

I have a protected word 2003 form template with 20 column heads. The users
would like to select 1 of 52 entries from a dropdown that would proliferate
each of the column head cells in the table. Can I set up one user form with
the list of items that can be used to populate all the heads or do I have to
set-up/attach it to a separate bookmark in each of the 20 cells? The cells
are populated with a brief skill-set description and each could be different.

Regards - Lenny

 

[Jay Freedman]

I have a protected word 2003 form template with 20 column heads. The
users would like to select 1 of 52 entries from a dropdown that would
proliferate each of the column head cells in the table. Can I set up
one user form with the list of items that can be used to populate all
the heads or do I have to set-up/attach it to a separate bookmark in
each of the 20 cells? The cells are populated with a brief skill-set
description and each could be different.

Regards - Lenny

Sorry, my crystal ball is out for repairs, so I can't divine the meaning of
"select 1 of 52 entries from a dropdown that would proliferate each of the
column head cells in the table".

Do you intend all 20 of the column heads to show the same text from a single
selection in the dropdown, or should each column head have an independent
selection from the dropdown?

Either result can be achieved, you just need to know which one you want.

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

 

[Lenny]

: Jay the dropdown list of 52 items is the same for each one of
the 20 heads. The end result however, is that after the user makes their
selection from the dropdown, each column head could be a different selection
from the list.

About a year ago I set up a purchase order that had a list of pre-defined
items as a jumping off point for items shipped. I set up a word form and
after trial and lots of error, discovered that I had to have a different
bookmark for each row, but the code had to be altered and named for each row
for everything to work. I still don't know if that was the correct way to
set it up, but it works.

I am hoping to get the code set up so it is easier and not as cumberson this
time (also a learning opportunity!) Regards - Lenny

Please let me know if this needs additional explanation.

 

[Graham Mayor]

You have 20 columns?
Do you want the dropdown list (userform) to appear 20 times so that users
can make independent selections for each column?
Do you want the userform to appear once and the user make 20 selections from
it?
Do you want the userform to appear once and the user make one selection from
which all the column headings are populated?

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


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

 

[Lenny]

: yes, 20 columns. In the purchase order form I set up, I
ended up with a dropdown for each line of entry.... it sounds like from your
response below that I have my answer. I will have to have a dropdown for
each of the columns. Just a quick question -- can I place all the routines
into the same module? I created a module for each of dropdowns in the prior
form and was not sure if it was required or not.... Regards - Lenny

 

[Graham Mayor]

If you are calling the same userform from an entry macro for each column you
only need one routine, one module. If it helps there is a routine at
http://www.gmayor.com/formfieldmacros.htm that demonstrates how to determine
which form field you are currently in (used there for input validation),
which you can probably adapt to be used by your userform.

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


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