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 or creates new line to fit the the data so that when
the user print the sheet, all the data will be displayed on a paper?

Any ideas?

Any help is appreciated.
Thanks in advanced.