Hello again!

I am so close to having this figured out and greatly appreciate everyone on this site. I think I may need a bit more help to get this document where I need it.

I have a drop down CC dependent on a multiselect listbox and I have added an additional drop down I would like to be dependent on the first dependent drop down. The dropdown titled "What line should say" should be dependent on the selection of drop down titled "Line" which is currently dependent on the listbox titled "Section". Can you help with the coding to make this work?

Another concern I have is with duplicate display names. Is it possible to have the same choice for multiple different listbox selections? I attempted to add the same choice to the drop down for different cases and received a runtime error, "An entry with the same display name already exists". Can this be ignored/avoided? I would like some choices to be possible for multiple different listbox cases but not actually duplicate on the drop down.

Thank you again!

Attached Files

Templatev4.5.docm (51.7 KB, 8 views)

Huzzah! I think I managed to work out all the dependent drop downs!

Still curious about the run time error however. Any way to enable repeat display names? I thought the value listed next to each display name would make them unique if they were all different, but I guess not?