Merge Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi to all!

I created a form in which the user at some point can write some text in some
merge cells.

I know that you can only put about 1k of characters in a cell, event if the
cell is merge, and by using some code you can incrase the size. This is for
text that is already predetermined or under your control.

What can be done for text to which we have no control, everything is
depended on the amount of text inputed by the user.

Is there a way for me to enable the user to type in all the text that they
want to type in?

Thanks for all your help.

Cheers

Ren
 
Cells can hold 32K characters whether merged or not. They can only
display/print approximately 1024 characters whether merged or not. You can
increase the number of characters displayed and printed by putting in hard
returns embedded in the text. So you could have your code put in such
returns after the user has made their entries (or they could do it as they
type Alt+Enter).
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Best solution to merge multiple Outlook contacts easily 2
Excel 2013 Merge Data 2
Prevent user input, if adjacent cell text is identical 6
wrap text in merge cells 7
find function not working with merged cells 2
Is there a maximum number of characters allowed in a cell? 1
Excel Typed text appears in wrong cell 0

Back
Top