I am using Office 2010, and would like to use a drop down, populated from an excel sheet, to pull data into other fields into word.


e.g. drop down is populated from excel column A, use drop down to select row 3. pull B3, B4, B5 into word fields.

Is this possible through VBA? if so, can someone point me in the right direction to get some info to accomplish this?

Thanks!