Formating cells in worksheet

[cilruca]

With Excel and VBA I developed a complety administrative system for my company. Print formats are all in Excel including invoices, delivery notes, quotations, etc.
Description of items sold, quoted, shipped normally contain so many characters that in order to make them fit in the pre-printed forms I have to combine various cells so that text fills the number of columns assigned to description.
Say for instance that description must fit the width of columns C to H. I start in row 4. If I start filling in description in C4, I would to know if it is possible to have Excel limited to these boundaries and whenever description reaches column H and there are more characters to type, automatically Excel goes to cell C5 to continue typing?
I have not been able to come up with a solution other than combining cells in row 4 (that is, range C4:H4) but every time I have to undo this combination to give way to a new description in a new document.
Is there a solution to this problem?
I will appreciate any help that you can provide. Thanks in advance.
Fernando Azouth
General Manager
Cilru, C.A.
cilruca@cantv.net

[JBeaucaire]

Once a cell in a worksheet is activated for user typing, all other activity is suspended. There is no worksheet level event that could interrupt the typing and move to another cell. The user has absolute control.

Now, you could use data validation (Allow: Text Length) on cells to limit the number of characters allowed to be typed so the USER would have to move to the next cell.

[Justin Young]

In the situation that I think you are referring to, you cannot make Excel adjust as you type but you can have Excel fix the text after you've entered it.

First, highlight the number of rows and columns you want the text to occupy, then choose Edit | Fill | Justify in Excel 2000-2003. In Excel 2007 choose Home | Editing | Fill | Justify.