Hi



I'm a newbie so be gentle ;-)

I've searched high and low for an answer to my question. I apologise if this appears on another thread but couldn't find it...so please feel free to point me in right direction.

I am creating a Word document in Word 2007 which will be a form for a user to complete. I have created drop down menus within the document and they all work fine.

However, I want a sub drop down menu (not sure if that's even the right terminology). For example, if the user selects "Administration" from the drop down list, a sub list becomes available to show the 5 options available under this category or if the user selects "Cleaning" then a different drop down list appears with the 3 options available under this catoegory.

I've Googled til my eyes are ready to drop out and can see that this is possible in Excel (even though I couldn't get it to work but putting it down to frustration).

Is something like this possible in Word 2007 and if so, is there a tutorial or someone who knows how to do this that could help me?

Many thanks in anticipation :-)

Lynn

Doing this within the document, itself, would be very difficult, at least for me. Consider, instead, using a UserForm. That can gather the information you want with sub menus becoming available depending on initial responses. Then the information gathered by the UserForm is transferred into the document.
Create a Simple Userform
Create & Employ a Userform

See, for example:

Dependent Dropdown Content Controls
https://www.msofficeforums.com/word-...html#post77762

Hierarchical Dropdown Content Controls
https://www.msofficeforums.com/word-...html#post94603

Dependent Text Content Controls
https://www.msofficeforums.com/word-...html#post46903

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, guys...will try both...

:-)

Hi

Still struggling with this...apologies...I've not done visual basic since my Uni days but think this option is better than the userform option.

The code provided in the example...I thought it would be just a case of replace key words with my own words e.g.:-

If .Title = "Master" Then
Select Case .Range.Text
Case "Option1"
StrOut = "Apples,Bananas,Cherries,Dates"
Case "Option2"
StrOut = "Fire,Earth,Air,Water"
Case "Option3"
StrOut = "Scissors,Paper,Rock"
Case Else
StrOut = ""
End Select

Replace Option1 with Administration and then replace the StrOut with PA,Secretary. However, it doesn't change the result.

I then played about with InfoPath and actually got the drop downs to work but I can't copy and paste them into Word.

I'm almost ready to throw in the towel but thought I would try picking your brains one more time.

Any ideas, views, musings welcome.

Lynn :-)

Hi, guys

I had a moment of clarity and have got it working!!!! I forgot to amend the properties!!!!

It's totally working and I could not be happier...

Many many thanks to you for helping...

Lynn :-D