View Single Post
  #1   Report Post  
cycle_simon cycle_simon is offline
Junior Member
 
Posts: 2
Default

Thanks everyone for your suggestions. The concensus seems to be using a text box.

Silly newbie question:

Is this a text box off the Control Toolbar?

Also, is there a way to make the text box expand automaticlly as the amount of text increases, or how do you add/combine the vertical scroll bar to the text box so that all the text is easily viewable?

Hopefully, one last part to this question:

is there a way to put horizontal lines in the textbox so that when the form is printed and completed in hardcopy, the respondent would have a lined area to write the response?

Thanks again.

cycle_simon

Quote:
Originally Posted by cycle_simon View Post
I'm setting up a questionnaire in Excel and certain responses will be open-ended text (the respondent can write as much as they like).

What is the best way to capture this i.e., create 1 large cell to type freely in or some sort of text box?

Appreciate your suggestions.

S.

Last edited by cycle_simon : June 11th 07 at 04:55 PM