M
Matt
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.
please point me in the right direction? I need the ability to show/see as
many characters as possible. Somewhere around 6k.
Thanks
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.
I don't know how to apply the "vbNewLine constant by code". Can someoneKevin B said: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.
please point me in the right direction? I need the ability to show/see as
many characters as possible. Somewhere around 6k.
Thanks