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