VBA to copy selected value of dropdown in Word Doc into specific Excel cell

excel vba ms-word dropdownbox
user1771800 picture user1771800 · Oct 24, 2012 · Viewed 8k times · Source

I am trying to return the text from a dropdown box that is selected on a Word form.

The word doc is a survey that contains a form with several dropdown boxes. I want to copy the value that the survey respondent selected from each dropdown into specific cells in Excel.

I have tried things such as:

Activedocument.DropDowns("DropDown1").Value;
Activedocument.DropDowns("DropDown1").Text; 
Activedocument.DropDowns("DropDown1").SelectedValue; 
Activedocument.Shapes("DropDown1").Value etc etc.

Current applicable parts of my code:

Dim dd14 As FormFields
With ActiveDocument
Set dd14 = ActiveDocument.FormFields("Dropdown14").DropDown.Value
Cells(iRow + 1, "H") = dd14
End With

Answer

scott picture scott · Oct 24, 2012

To reference the value for a legacy form dropdown field to get the value (which is the index, not the text of the selected item) the code is:

  activedocument.FormFields("dropdown1").DropDown.value

Related questions

Read lines from a text file but skip the first two lines

I've got this macro code in Microsoft Office Word 2003 which reads the lines of a text file. The lines each represent a string value that I need to use later in the code. However, the first two lines of the …

Read More
Macro to export MS Word tables to Excel sheets

I have a word document with many tables. Does anyone know how to write a macro to export such tables to different Excel sheets?

Read More
Generate Word Documents (in Excel VBA) from a series of Document Templates

Hey all. I'll try to make this brief and simple. :) I have 40 or so boilerplate word documents with a series of fields (Name, address, etc) that need to be filled in. This is historically done manually, but it's repetitive and …

Read More