Re: Getting around 25 item dropdown limitation

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Lenny wrote:
"Lenny" wrote: 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" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Lenny wrote:
"Lenny" wrote: 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.

"Jay Freedman" wrote:

Lenny wrote:
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 FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.


.

Relevant Pages

  • Re: Getting around 25 item dropdown limitation
    ... Do you want the dropdown list to appear 20 times so that users ... Do you want the userform to appear once and the user make 20 selections from ... Do you want the userform to appear once and the user make one selection from ... would proliferate each of the column head cells in the table. ...
    (microsoft.public.word.vba.general)
  • Re: Getting around 25 item dropdown limitation
    ... "Lenny" wrote: yes, 20 columns. ... ended up with a dropdown for each line of entry.... ... Do you want the userform to appear once and the user make one selection from ... would proliferate each of the column head cells in the table. ...
    (microsoft.public.word.vba.general)
  • Re: Getting around 25 item dropdown limitation
    ... proliferate each of the column head cells in the table. ... selection in the dropdown, or should each column head have an independent ...
    (microsoft.public.word.vba.general)
  • Re: Calculating off combobox selections
    ... selection from the dropdown combobox list in field A. That's it! ... 'number') in field 'B' based on the selection from the dropdown combobox. ... There is no 'combo box' form field in Word 2003, ...
    (microsoft.public.word.docmanagement)
  • Re: UserForm VBA - pulldown menu - Word2003
    ... > My scenario is to have one template for our team to use to standardize ... I have setup the userform in VBA to obtain all the personal ... >> Add the logo pictures as AutoText entries in the template, ... >> the logo to appear in the form, insert a dropdown form field. ...
    (microsoft.public.word.vba.beginners)
Loading