Creating forms using the form toolbar

[Guest]

I have re-written my questionnaire using the form toolbar and checkboxes. I
have also managed to create the macro that makes checkboxes act as radio
buttons - it all seems very difficult i hope i am doing the easiest thing?
The layout is not as neat as it was when i was using the control toolbox is
there a way to improve this - tables for the multiple answer questions?
the other problem is the questionnaire consists of some yes/no answers and
some where the user can select any number of options; is there anyway to
collect data from all the responses without going thru them manually?
eventually the data from the quiz will be put into excel.
Thank you

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?V2VuZHk=?=,

I have re-written my questionnaire using the form toolbar and checkboxes. I
have also managed to create the macro that makes checkboxes act as radio
buttons - it all seems very difficult i hope i am doing the easiest thing?
The layout is not as neat as it was when i was using the control toolbox is
there a way to improve this - tables for the multiple answer questions?
the other problem is the questionnaire consists of some yes/no answers and
some where the user can select any number of options; is there anyway to
collect data from all the responses without going thru them manually?
eventually the data from the quiz will be put into excel.

Yes, you can use tables to help structure the questionnaires layout.

I'm sure there are easier ways to create a questionnaire, but not using Word.

As with the "radio buttons", you'd need to use a macro to pull out the data
and put it into Excel if you don't want to do it "by hand". That topic you
should pursue in a word.vba newsgroup - you'll find more people there to help
with programming the macro than in this end-user newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail