I would like to create a document in Word which I can select a country from a drop down menu, and based off this selection a text box automatically fills in information from the relevant data for that country from an excel spreadsheet.

is this even possible? I am new to VBA so detailed answers would be very much appreciated!