Searchable drop-down list in Word

[max76]

Hi Graham,

Thank you again for your help! However, I still can't figure out one thing. When triggering the userform, the list box is populated with the items from the first workshetet (ID) which is not the purpose of my macro.

In the Word file that I had attached in my previous email, you can find a content control under the arrow with items matching the exact names of a few worksheets in the Errors.xls file (I only put a few to simplify). So the list box must be "dynamic" so to speak and get the worksheet name from the value in that content control (I know how to retrieve the value but I don't know where to put that code). Could you please show me where I can do that in your code? I need the worksheet populating the list box to be referred to as a string value rather than an index.

I also noted that the first row in the worksheet is skipped I thought that it was possible to select that the columns have no header.

Items.jpg

Thank you

Regards
Massimo