A cell can hold 32K characters. So I don't think you will have a problem
unless you approach that amount.

Just be advised, that without special efforts, only 1024 of those characters
will be displayed or printed in the sheet. Special efforts would include
inserting hard returns within your data.

--
Regards,
Tom Ogilvy

--
Regards,
Tom Ogilvy


"N E Body" wrote in message
...
Hi

Is there a limit to the number of characters allowed in a cell (or is it
just a limit to the size of a formula)

I have a userform which has a textbox for collecting information. The
user
types a message (some of which can be quite long.)
The code runs and does various things including transfering the text from
the textbox into a cell on the worksheet.

Will I have any limitations?

Kenny
Win 2000 and Excel97