Hi Kait,

Your code fails because there's and 'End If' missing between 'End If' and 'End With'.

Having said that, I can't see why you've made it so complicated. The much simpler code I pasted was all you needed. Indeed, your code is going to create problems by adding new (duplicate) entries to each dropdown formfield and, when you exceed 25, the code will fail.

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