Exceed the 256 char limit for text in a cell

  • Thread starter Thread starter rlcohen
  • Start date Start date
R

rlcohen

Hello,
I need to be able to provide a user with a text window for them to typ
in information in Excel. The challenge is that I understand that ther
is a 256 char limit. I have to build the Excel doc to work in Exce
2000.

Is there a way I can provide one cell or text box and allow the user t
imput more than 256 chars???

Thank
 
A hard return (<Alt> <Enter>), will bypass the 256 character limit.
The exact limit that can actually be contained is around 32,000, BUT, that
all can't be displayed!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello,
I need to be able to provide a user with a text window for them to type
in information in Excel. The challenge is that I understand that there
is a 256 char limit. I have to build the Excel doc to work in Excel
2000.

Is there a way I can provide one cell or text box and allow the user to
imput more than 256 chars???

Thanks
 
rlcohen > said:
I need to be able to provide a user with a text window for them to type
in information in Excel. The challenge is that I understand that there
is a 256 char limit. I have to build the Excel doc to work in Excel
2000.

Is there a way I can provide one cell or text box and allow the user to
imput more than 256 chars???
Click to expand...

What do you mean by 'text window'?

Excel cells can contain 32,767 chars, but only a fraction of them can be
displayed in readable typesizes. Drawing text boxes can display more, and
work better for free-form text entry.
 
The challenge is most of the users will just let word wrap take over or
press enter. Is there something I can program in using VB to over come
this and behind the scenes allow them to do this?

My goal would be to have a text box and they just enter what they need.
Lets say 1/4 quarter of a page.

It is for an emplyee review. The reviewer needs to enter comments and
the employee has an opportunity to reply.
 
Back
Top