Create new line to allocate long data

[Rizana]

I'm working on a program that enabled the user to insert data via forms in VBE.
The data will then directly send to Excel worksheets as database. Besides, the user can print the data in Excel sheets.

The problem is that, what if the user enter a very long data?(much longer than the cell that I've already allocated for it)

Is there any other way I could directly asked Ms Excel program to lengthen the cell according to the length of the data so that when the user print the sheet, all the data will be appeared?

Any help is appreciated.
Thanks in advanced.

 

[agihcam]

question: do you really allow the users to input a very long text? or you want to control it and prompt them the max length of the text?

 

[Rizana]

according to the plan, I actually allowed the user to input a long text.

 

[agihcam]

Is there any other way I could directly asked Ms Excel program to lengthen the cell according to the length of the data so that when the user print the sheet, all the data will be appeared?

please elaborate this.