Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gathering open-ended question text into one sheet DaveCVC Excel Discussion (Misc queries) 1 March 18th 05 05:57 PM
open ended multi page sum AlZee Excel Worksheet Functions 2 November 1st 04 10:53 PM
open ended multi page sum AlZee Excel Worksheet Functions 1 November 1st 04 01:26 AM
open ended multi page sum AlZee Excel Worksheet Functions 2 October 31st 04 05:49 PM
open ended multi page sum AlZee Excel Worksheet Functions 3 October 30th 04 11:30 PM


All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"