I have created a survey in excel (2003). I have put boxes in for people to
make further comment. The problem is that if their comments are longer than
the box it pushes the rest of the survey down. I was wondering if its
possible to add a box with a scroll bar and if this can be done how do I do
it. Thanks in advance.

hi

Try this one:

Put text box using control toolbox (to get control toolbox right click on the empty sapce on the menubar)
click properties on the control toolbox
click categorise tab
select multiLine as true under Behaviour
select 2-fmScrollBarsVertical under Scrolling
Exit the design mode

This will do ur requirement.



"Lynda" wrote:

I have created a survey in excel (2003). I have put boxes in for people to
make further comment. The problem is that if their comments are longer than
the box it pushes the rest of the survey down. I was wondering if its
possible to add a box with a scroll bar and if this can be done how do I do
it. Thanks in advance.

Thank you Rajesh, that's perfect exactly what i want.

Cheers
Lynda

"rajesh" wrote:

hi

Try this one:

Put text box using control toolbox (to get control toolbox right click on the empty sapce on the menubar)
click properties on the control toolbox
click categorise tab
select multiLine as true under Behaviour
select 2-fmScrollBarsVertical under Scrolling
Exit the design mode

This will do ur requirement.



"Lynda" wrote:

I have created a survey in excel (2003). I have put boxes in for people to
make further comment. The problem is that if their comments are longer than
the box it pushes the rest of the survey down. I was wondering if its
possible to add a box with a scroll bar and if this can be done how do I do
it. Thanks in advance.