automatically creates new space according to data

  • Thread starter Thread starter rixanna
  • Start date Start date
R

rixanna

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.
 
This is most certainly possible but it seems to me you may be using the
wrong tool in the first place. Is there any reason you are not using
Access or similar which has such data validation built in?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Excel How to extract the data from Excel . 0
Copy Data from One sheet to Different Sheets 1
Retrieving data from a cell in the last row containing data in the worksheet 1
Imbedded Data Input sheet 3
Hide empty rows in Excel worksheets 5

Back
Top