Thanks, macropod, your macro works well. I am revamping an old form and trying to make it easier to manage with the list data in an Excel file. I am using the macro with this variation:

ActiveDocument.ContentControls(1)

How could I adapt this so that all my dropdown lists are updated, rather than call them individually, I call them all as a group or collective? I hope that makes sense.

Thanks.

Liz