View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anita Anita is offline
external usenet poster
 
Posts: 71
Default 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