Exceed the 256 char limit for text in a cell

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
 
R

RagDyer

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
 
R

rlcohen

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