I would like to create a survey that contains a number of check boxes or some other binary field for a "yes"/"no" answer to the questions. It may also contain some number fields for the user to input some numbers (ex: number of family members). Is there any way that I can do this in Word and then write a macro to dump the answers into a spreadsheet to make it easy to track the results? I'm having trouble trying to figure out how to reference a control box in Word and then take the contents and put it in a cell in Excel.



Is this possible? Any guidance would be much appreciated.