"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.


OK, I am having the issue of needing to see more than the 1024 limit in a
cell. Mine is a merged cell (almost a full page) and I don't know how to
apply the "vbNewLine constant by code". Can someone please point me in the
right direction?

I have a protected form for people to fill out. It will NOT be unprotected
by the users to complete. I need the ability to show as many characters as
possible. Somewhere around 6k.

Thanks