Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a form in excel? | Excel Discussion (Misc queries) | |||
How do I create a form in Excel? | Excel Worksheet Functions | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
How do I create a form in Excel? | Excel Discussion (Misc queries) |