Hi Shaun,
I moved this to the Word vba forum and retitled it.
Please feel free to edit the title if I got it wrong. What I used is:
Filling in legacy dropdown and using result to display information.

I think you would be better off with a UserForm, myself.

• Create & Employ a Userform by Greg Maxey
• Create a Simple Userform by Graham Mayor, MVP

Does this need to be in a document protected for filling in forms?