Create a form in Excel
 

I've set up a template in Excel that I send out to customers to fill in. It
looks nice but the people who fill it in don't necessarily know how to use
Excel!

I have no VB experience and want the form to be protected so that they can
only fill in certain boxes. I have got tick boxes on the form that need to
be 'live' and there are some large areas where text needs to be input - this
typically needs to be a box which will automatically wrap onto the next line
and if possible allow the user to press return to start a new line. I think
there is a limit on number of chars in Excel and need to overcome if poss.

Can I do this without using VB - any tips or advice would be gratefully
received.

Excel 2003 by the way....

Thanks

Anita

Create a form in Excel
 

On text wrapping

Select the cell in which you need to have multi-line text. Right
click--Format cells--Alignment-- Check Wrap Text..


If this post helps click Yes
---------------
Jacob Skaria


"Anita" wrote:

I've set up a template in Excel that I send out to customers to fill in. It
looks nice but the people who fill it in don't necessarily know how to use
Excel!

I have no VB experience and want the form to be protected so that they can
only fill in certain boxes. I have got tick boxes on the form that need to
be 'live' and there are some large areas where text needs to be input - this
typically needs to be a box which will automatically wrap onto the next line
and if possible allow the user to press return to start a new line. I think
there is a limit on number of chars in Excel and need to overcome if poss.

Can I do this without using VB - any tips or advice would be gratefully
received.

Excel 2003 by the way....

Thanks

Anita