Hi everyone,

I need your support to get a searchable drop-down list to work in Word as it does in Excel. I transferred the VBA code from Excel to the Word file (see attached filed).
I added some coding in the modMain module to point to the Excel workbook from Word. When I click on the button on Word to trigger the Main module, the userform is opened but no list is generated when I start typing text in the textbox above.
I tried to debug the macros and I found the error in the UserFormBook shown in the photo attached.

Can somebody shed some light on the issue that prevents the list from being populated in Word?

Thank you in advance for your help!

Regards
MassimoSearchable dropdown list.zip