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
|