Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Drop-down list in Word 2007

    I am working on a drop-down list in word 2007. I have several questions:

    1. My drop down list is based on an excel list (see attahced excel example file). The list is pretty long. I don't mind typing these items in my Word drop-down list but I am wondering if a) The list is too long for word to handle. And b) if I can use the excel list as a source file for my drop-down list.

    2. I am also attahcing an example in Word. All the fields e.g. Job Function, Job Family, Job Code and Pay Level will eventully be a drop-down list if I can figure out how to do it. And one other thing I wanted to acheive is to be able to make the form a little smarter. For example, If anyone choose job function "HR", the job family drop-down list will only show "HR" realted job fmaily (based on the excel list) instead of every job family. Same for Job Code drop-down list - If anyone choose job function "HR", the Job Code drop-down list will only show "HR" related job code.

    I am fairly new to all the VBA code. Can somebody here help me?

    Thanks a lot!

    Stella
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    I don't believe having one drop-down depend on the previous, etc. is very easy in either Word or Excel.
    I have faced a similar situation in Excel only and had to create all of the sub-lists separately with tests in the validation.
    I recall seeing saw some VB code for Excel but wasn't able to get it to work (not that the code was bad, it was ME trying to modify it).
    It sounds more like a job for Access than either Word or Excel.

    Hopefully, someone will come up with a good approach.

    Here's an example of how I was forced to do it.
    Attached Files Attached Files
    Last edited by kweaver; 2012-08-03 at 18:40.

  3. The Following User Says Thank You to kweaver For This Useful Post:

    Stella2 (2012-08-06)

  4. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts
    Here's an example of two content controls where the value of one causes the drop-down list of the other to change.
    Attached Files Attached Files

  5. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #5
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Willow Grove, Pennsylvania, USA
    Posts
    205
    Thanks
    4
    Thanked 49 Times in 40 Posts
    You can do linked dropdown lists in Word, as illustrated in http://gregmaxey.mvps.org/word_tip_p...own_lists.html.

    Dropdown legacy form fields (as opposed to content controls) in all versions of Word are limited to 25 entries per field. In a quick look at your Excel file, I don't think any of your categories exceed that limit, but some of them are close; if a few more families are added to some of the function categories, then form fields won't work any more. You might be better advised to start immediately with a userform (http://gregmaxey.mvps.org/word_tip_p...m_listbox.html) in which the dropdown lists are not limited.

    These articles and the ones cited in the other replies should get you started. If you hit a specific problem, post back and describe the exact logic you're trying to execute.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •