I have 2 issues.

1 - I have a protected form for people to fill out. It will NOT be
unprotected by the users to complete. I have a merged cell (almost a full
page) and when text is entered and is below 1024 characters, all you see is:
########## Why is this?

This leads into my other issue since 1024 is the limit.
2 - Below is a copy of an answer to a question regarding the 1024 character
limit in a cell. The question was from earlier this month (original post
date). Not knowing how often old posts are looked at for questions I have
pasted the answer here.

"Kevin B" wrote:

There is a 32,767 character limit per cell, with only 1,024 displayed. You
can extend the 1,024 limit by forcing line breaks with <Alt + Enter if
typing, or vbNewLine constant by code.


I don't know how to apply the "vbNewLine constant by code". Can someone
please point me in the right direction? I need the ability to show/see as
many characters as possible. Somewhere around 6k.

Thanks